excel formula condition

Microsoft Excel: mac 2008 (mac)
November 7, 2009 at 15:31:34
Specs: Macintosh/PC
I have a client that needs a formula to calculate the total cost of meals on monday thru friday... easy enuff =(a2+b2+c2+d2+e2)

however, on certain days, shop is closed, and the client wants to put the text "closed" on these days. when I do this, my formula returns a #VALUE! error. is there a way around this?

See More: excel formula condition

Report •

November 7, 2009 at 17:57:02
Have your friend try either of these syntaxes...they should all work:

=SUM(A2:E2) for contiguous cells


=SUM(A2,B2,C2,D2,E2) for contiguous or non-contiguous cells


=SUM(A2,B2,C2:E2) for combinations of contiguous and non-contiguous cells

The SUM function will ignore cells that contain text.

Report •
Related Solutions

Ask Question