Hello,
I am looking to add cell values together, i keep having the value column, an e.g. of what i am trying to add below:
<tbody>
</tbody>
I am trying to add the amount sold on each day (in the above e.g. Day 1), I want the formula to ignore cells with the word Sick or PTO, i can't use SUM or "<>#N/A" because the cells i am adding up are random and not in a grouped together range, I need to be able to drag the formula across as it will eventually cover a full year.
Thank you!
I am looking to add cell values together, i keep having the value column, an e.g. of what i am trying to add below:
Cell | Person | Day 1 |
A1 | User 1 | 10 |
A10 | User 2 | 0 |
A16 | User 3 | Sick |
A84 | User 4 | Pto |
A101 | User 5 | 9 |
A122 | User 6 | 12 |
<tbody>
</tbody>
I am trying to add the amount sold on each day (in the above e.g. Day 1), I want the formula to ignore cells with the word Sick or PTO, i can't use SUM or "<>#N/A" because the cells i am adding up are random and not in a grouped together range, I need to be able to drag the formula across as it will eventually cover a full year.
Thank you!