Good day,
I have been struggling to calculate the below. What I would like to calculate is if T is blank or 0 and A is equal 1. I need to know the sum. I have been trying with Sumif, sumproduct and countif without success. in the below example the answer should be 3. Any help will greatly be appreciated.
<tbody>
</tbody>
I have been struggling to calculate the below. What I would like to calculate is if T is blank or 0 and A is equal 1. I need to know the sum. I have been trying with Sumif, sumproduct and countif without success. in the below example the answer should be 3. Any help will greatly be appreciated.
T | A | T | A | T | A | T | A | T | A | T | A | T Total | A Total | O Only A not T |
| 1 | 1 | | 1 | 1 | | 1 | 1 | | | 1 | 3 | 4 | 3 |
<tbody>
</tbody>