SUM Formula returning value as 'zero'

Sam L

New member
Joined
Aug 23, 2012
Messages
1
Reaction score
0
Points
0
Could someone help please. When I use the SUM formula of a group of cells containing other formulas, it returns as a zero value.

I have attached an example and the problem lies in cell D30.

Any help would be much appreciated.
 

Attachments

  • Example Spreadsheet.xlsx
    24.5 KB · Views: 17

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,940
Reaction score
0
Points
36
Excel Version(s)
O365
FIXED creates a text string, SUM works on numbers.

Get rid of the FIXED and concatenating " m" in the formula and use a custom of format of #,##0.00 " m" and then the SUM will work.
 

tommyt61

New member
Joined
Mar 26, 2011
Messages
153
Reaction score
0
Points
0
Scratch ..... didn't notice Bob had already posted an answer.
 
Last edited:
Top