Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

excel formula condition

Comment:

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?

Name: DerbyDad03
Date: November 7, 2009 at 17:57:02 Pacific

Reply:

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.

0

Links in Email - IE remai...

Dual Monitor issue?

Summary: I want to use Excel to score (done that bit) and evaluate a psychometric test. The test produces pairs of figures. Each figure can be pos or neg. Two steps One If both pos OR both neg I want absolute ...

Summary: Hi All I need some help with a certain Excel formula. Hopefully my explanation is clear enough. Basically I have 3 columns - Days, Hours and Minutes. Currently I put in data for each column and it is ...

Summary: For no apparent reason I have encountered problems with excel formulas. Instead of dragging formulas across columns, my speadsheets are copying information only. Also, summed columns of figures are no...