I appear to be not sufficiently expert to use the SUM function surrounded by excel.
Everytime i use the sum function, my result returns as 0.
The correct result returns if i use the + function, ie, A3 = a1+a2.
I own tried every possible cell format for both the inventory of numbers and for the formual cell. I hold also removed adjectives formatting on the sheet and copy the array of numbers and paste them as values...
No issue what the format, I achieve 0 when using the SUM function.
Answers: The sum is solitary biddable for solid numbers. If you put within an alpha-numeric number, Excel think its a word and consequently equal to not anything.
Hi,
did you a short time ago type the formula into the cell ?? basically click the cell you want to sum and permit the wizard do it adjectives for you. hope this help you.
use this format
=sum(a1:a2)
A1 and A2 is the variety of cell you want to sum so you could =sum(a1:a3333333) if you wish
Enter this into cell A3, you do not type A3,
=sum(A1,A2)
or
=A1+A2