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?

Have your friend try either of these syntaxes...they should all work: =SUM(A2:E2) for contiguous cells

or

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

or

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

The SUM function will ignore cells that contain text.

Ask Your Question

Weekly Poll

Do you think Monopoly should update its pieces?

Discuss in The Lounge

Poll History