Iain McBride
New Member
- Joined
- Aug 17, 2018
- Messages
- 38
Hi - another query for people more Excel savvy than me......
I am trying to make a cumulative total of people attendance from different spreadsheets onto a master template but discounting the term "#N/A"
So, I am trying to total the numbers from cells C15:AH15
<tbody>
</tbody>
The auto calculation I have doesn't work but the cells carry #N/A when not completed - is there a way to add all the cells up (but ignoring cells with "#N/A"?
Thanks - sorry for the poor explanation!!!
I am trying to make a cumulative total of people attendance from different spreadsheets onto a master template but discounting the term "#N/A"
So, I am trying to total the numbers from cells C15:AH15
B | C | D | E | F | G | H | I | J | K | L | M | N | O | |
... | Bob | Y | Y | Y | Y | Y | ||||||||
4 | Joe | Y | Y | Y | Y | N | ||||||||
5 | Sal | Y | Y | Y | Y | Y | ||||||||
6 | Vernon | Y | Y | Y | Y | Y | ||||||||
7 | ... | Y | Y | Y | Y | N | ||||||||
8 | ... | Y | N | Y | N | N | ||||||||
9 | ... | Y | Y | Y | N | Y | ||||||||
10 | ... | Y | N | Y | N | Y | ||||||||
11 | ... | Y | Y | Y | Y | Y | ||||||||
12 | ... | Y | N | Y | Y | Y | ||||||||
13 | ... | Y | N | Y | Y | Y | ||||||||
14 | ... | Y | Y | Y | Y | Y | ||||||||
15 | 12 | 8 | 12 | 9 | 9 | #N/A | #N/A<strike></strike> | #N/A | #N/A<strike></strike> | #N/A | #N/A<strike></strike> | #N/A | #N/A<strike></strike> | |
<strike></strike> |
<tbody>
</tbody>
The auto calculation I have doesn't work but the cells carry #N/A when not completed - is there a way to add all the cells up (but ignoring cells with "#N/A"?
Thanks - sorry for the poor explanation!!!