| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 102814 | 2009-09-02 10:19:00 | Excel Question | Mercury (1316) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 806317 | 2009-09-02 10:19:00 | 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. |
Mercury (1316) | ||
| 806318 | 2009-09-02 10:32:00 | 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 |
TeejayR (4271) | ||
| 806319 | 2009-09-02 10:36:00 | Would the =Sum Function be any use? | B.M. (505) | ||
| 806320 | 2009-09-02 10:56:00 | 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 (1316) | ||
| 806321 | 2009-09-02 11:01:00 | Got it! COUNT Function. =COUNT(C11,F11,I11,L11,O11) |
Mercury (1316) | ||
| 1 | |||||