Excel 2007 : Only display a zero if there is one actually entered ??

[Turbo Dog]

Howdy all...my first post here, but I have searched out other answers from this form and would like to say thanks for all the help so far.

I'm using this formula in P11 to keep a cell blank so that the spreadsheet can printed and used as a form: =IF(L11+M11+N11+O11>0,L11+M11+N11+O11,"")

The form is taken out into some remote areas to gather some data, then the user comes back to the office and fills out the electronic copy. The problem is that if the data entered in L11, M11, N11, or O11 is zero then P11 does not display a zero, it remains blank due to the formula but I need it to show a zero in this case.
I have tried using: =IF(ISNUMBER(K11),K11+L11+M11+N11,"") but that always displays a zero.

Does anyone know a way to only display a zero in P11 if a zero is actually entered into on of the L11, M11, N11, or O11 cells?

[daddylonglegs]

Try using COUNT function to test (COUNT counts only numbers....including zero)

=IF(COUNT(L11:O11)>0,SUM(L11:O11),"")

[Turbo Dog]

THANKS...that works perfectly!