0
Am unable to do SUM function in Excel when numbers are with pound symbol example pound124 pound247 but am able to do the perform SUM function with normal number?
Wiki User
∙ 9y ago
A possible explanation is that you are typing the pound sign in yourself. If the cell content is left aligned, then it is being treated like text and so it cannot be summed. That is what happens if you type the pound sign in yourself. It thinks it is text, not a number. You should only ever type in actual numbers and then use the formatting options to add in the pound sign or whatever other symbols you may want. So type the numbers in with no signs. They should align to the right of the cell. Then use formatting to apply the pound signs. The pound signs will appear but your values will still be treated as numbers and will still be right aligned. Now you should be able to sum them.
Wiki User
∙ 9y ago
Add your answer:
Earn +20 pts
What is the function used to total a row of numbers?
=SUM(A1:A17) for example
How do you tell if a set of numbers is a function or not?
A set of numbers is never a function. A function is something that takes in a number and changes it into another number. For example y+2 takes in a number (y) and adds 2 to it. If y is 4, it produces 6.
Which function is used to randomize number in Excel?
There is a RAND function which can generate random numbers. The RANDBETWEEN function can generate numbers between a lower and upper limit.There is a RAND function which can generate random numbers. The RANDBETWEEN function can generate numbers between a lower and upper limit.There is a RAND function which can generate random numbers. The RANDBETWEEN function can generate numbers between a lower and upper limit.There is a RAND function which can generate random numbers. The RANDBETWEEN function can generate numbers between a lower and upper limit.There is a RAND function which can generate random numbers. The RANDBETWEEN function can generate numbers between a lower and upper limit.There is a RAND function which can generate random numbers. The RANDBETWEEN function can generate numbers between a lower and upper limit.There is a RAND function which can generate random numbers. The RANDBETWEEN function can generate numbers between a lower and upper limit.There is a RAND function which can generate random numbers. The RANDBETWEEN function can generate numbers between a lower and upper limit.There is a RAND function which can generate random numbers. The RANDBETWEEN function can generate numbers between a lower and upper limit.There is a RAND function which can generate random numbers. The RANDBETWEEN function can generate numbers between a lower and upper limit.There is a RAND function which can generate random numbers. The RANDBETWEEN function can generate numbers between a lower and upper limit.
A spreadsheet calculating the sum of 10 numbers entered into spreadsheet cells is an example of?
A formula. It can also be a function.
How do I know if a set of numbers are a function?
If one x-value does not have two y-values, then it is a function. In other words, x cannot be repeated. For example, take a parabola whose vertex is at the origin and points are all found in the first and fourth quadrants, forming a "c" of sorts. This graph would not pass the vertical-line test and would therefore not be considered a function.
What is the difference between argument and function in Excel?
A function is a built-in formula in Excel designed to do a particular task. Arguments are values that you provide to a function to do its task, like cell address that hold numbers that you want to use for the function. For example, the numbers and addresses in the following SUM function are arguments: =SUM( A2:A5, 7, 800, B18 )
What is the collection of all output values called?
All the output values of a function are collectively called the "range" of that function. For example, consider the function x2. Any number squared will give a positive. Thus, the "range" of the function is positive numbers.
The average function is determined by dividing sum function by what function?
The average of a set of numbers is equal to the sum of those numbers divided by the number of numbers. So, one might say that the average function is equal to the sum function divided by the count function.
Is a function that maps binary to natural numbers a bijection?
No. The set of binary numbers includes fractions which are written in binary form. For example, binary(0.1) = decimal(0.5) which is not a natural number.
What is the domain of logarithm and exponential function?
Domain of the logarithm function is the positive real numbers. Domain of exponential function is the real numbers.
Are a function's arguments in Excel always surrounded by quotation marks?
No. It depends on the data type. So numbers would not be in quotation marks for example.
What is Domain of the Function?
The domain of a function is the set of numbers that can be valid inputs into the function. Expressed another way, it is the set of numbers along the x-axis that have a corresponding solution on the y axis.
