Hi,
I'm currently trying to work out the following but been struggling to get the correct answer. If the contribution (See box below in what I am trying to do) is greater than or equal to 1, then it banks the number to the left handside and then updates the count in the box below.
For example, if the contribution is 1, it will bank the number 5,4,2 and 22 and add this to the overall count which exceeds >3 in the box below, total should be 33.
Another example is that if the contribution is 0, it will bank into the countif with a total of 8 in the final box below.
Another example is that if the contribution is 1, it will bank into the countif with a total of 33 in the final box below.
I did try to use countif however it requires a more complicated formula. I am using Office 2019 Professional Plus.
I would appreciate any guidance or assistance please.
I'm currently trying to work out the following but been struggling to get the correct answer. If the contribution (See box below in what I am trying to do) is greater than or equal to 1, then it banks the number to the left handside and then updates the count in the box below.
For example, if the contribution is 1, it will bank the number 5,4,2 and 22 and add this to the overall count which exceeds >3 in the box below, total should be 33.
Another example is that if the contribution is 0, it will bank into the countif with a total of 8 in the final box below.
Another example is that if the contribution is 1, it will bank into the countif with a total of 33 in the final box below.
I did try to use countif however it requires a more complicated formula. I am using Office 2019 Professional Plus.
Number | Contribution |
1 | 0 |
1 | 0 |
5 | 1 |
3 | 2 |
4 | 1 |
4 | 0 |
2 | 1 |
1 | 0 |
1 | 2 |
22 | 1 |
1 | 0 |
<1 | Counts go here | 18% |
1 | Counts go here | 73% |
2 | Counts go here | 9% |
3 | Counts go here | 0% |
>3 | Counts go here | 0% |
I would appreciate any guidance or assistance please.