PDA

View Full Version : Excel Question



Mercury
02-09-2009, 10:19 PM
I am creating an attendance record for a club.

Does anyone know how to add numbers in 5 non-consecutive cells together when these cells may not contain numbers but also words?

If someone is present then that is marked with the number 1
If they have apologized then the cell contains the word Apology.

Adding the 5 cells for July together brings an unhelpful #VALUE! so it obviously doesn't like the Apologies (come to think of it, neither do we!).

The reason for non-consecutive is that each week has 3 columns - attendance, guests and dollars. I don't want to change Apologies to 0 as we also have Late Apologies and No Shows that also need recording.

TeejayR
02-09-2009, 10:32 PM
You could try using the SUMIF formula

=SUMIF(A1:O1,1,A1:O1)

This adds together all the cells in the range A1:O1 (5x 3 columns) but only totals the column when it has a 1 in it

Trev

B.M.
02-09-2009, 10:36 PM
Would the =Sum Function be any use?

Mercury
02-09-2009, 10:56 PM
Unfortunately SUM and it's variations don't work. Throw in one guest in the second column and the guest gets added too.

Looks like I might have to try multiple IFs.

Mercury
02-09-2009, 11:01 PM
Got it!

COUNT Function.
=COUNT(C11,F11,I11,L11,O11)