Thread
:
sum() 0.00 result
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
Doc d
external usenet poster
Posts: 1
sum() 0.00 result
A report was exported to Excel. When using =sum(start:end) on a numerical
column the result is 0.00. But if use =cell1+cell2+cell3 the result is okay.
Tried using format as numerical, currency, and accounting to no avail.
Reply With Quote
Doc d
View Public Profile
Find all posts by Doc d