View Full Version : Excel Question

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.

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


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


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

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.

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

COUNT Function.