LeighWardle
asked on
Excel 2016 Spreadsheet - Sum of numbers in a column is incorrecly calculated to be zero
Hi Experts,
I've got a problem with the attached Excel 2016 Spreadsheet.
I'm trying to do some calculations on the 2nd Sheet, "csn".
I want to Sum the numbers in Column B.
My formula is in cell B52 = SUM(B2:B51).
Clearly it should be non-zero, but I am getting 0.0.
What am I overlooking?
Regards,
Leigh
AGPT02-17_AppE_TLD_VIC.XLSX
I've got a problem with the attached Excel 2016 Spreadsheet.
I'm trying to do some calculations on the 2nd Sheet, "csn".
I want to Sum the numbers in Column B.
My formula is in cell B52 = SUM(B2:B51).
Clearly it should be non-zero, but I am getting 0.0.
What am I overlooking?
Regards,
Leigh
AGPT02-17_AppE_TLD_VIC.XLSX
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Or you can try...
=SUMPRODUCT(VALUE(B2:B51))
ASKER
Thanks, Ares, that is the easiest solution.
Regards,
Leigh
Regards,
Leigh
use formula like:
Open in new window
to do the conversion.
AGPT02-17_AppE_TLD_VIC_b.XLSX