CountIf using four fields

[DexterG]

Hi All,

I have four columns.. Column A, B & C contain positive and negative numbers. Column D is a helper column with Values 1 & 2.

Every time there is a 2 in column D, I want to calculate in column E, no. of times there is a ">0" number in all Column A, B & C in the same row, for the range of numbers till the next 2 appears in column B.

The example below should help to understand what I mean.

A | B | C | D | E (desired result)
7 | 8 | 3 | 2 | 1
9 | 0 | 4 | 1 |
4 | 0 | 7 | 2 | 0
-3 | 0 0 | 1 |
2 | 0 | 2 | 1 |
-8 | 0 | 0 | 1 |
-8 | 0 | 1 | 1 |
3 | 6 | 8 | 2 | 1
-6 | 7 | 6 | 1 |
6 | 1 | 2 | 2 | 3
7 | 0 | 3 | 1 |
8 | 5 | 4 | 1 |
5 | 2 | 3 | 1 |
4 | 9 | 7 | 2 | 2
3 | 0 |5 | 1 |
5 | 2 | 1 | 1 |


Hoping some can help me quick!!

Much appreciated!!

[dilipandey]

HI DexterG,

no. of times there is a ">0"

You are counting Zeros or numbers greater than zeros ?
check the attachment :-
number greater than zero.xlsx

Regards,
DILIPandey
<click on below * if this helps>

[DexterG]

Hi Dilipandey,

Every time there is a 2 in column D, I want to calculate in column E, no. of times there is a ">0" number in all Column A, B & C at the same time i.e in the same row, for the range of numbers till the next 2 appears in column B.

The file I've attached might help you to understand better what I mean.

Thank you so much for the quick reply!

[dilipandey]

check the attachment... what if one number in a set (set of 3 numbers) is zero or -ve ?
Number greater than zero(1).xlsx


Regards,
DILIPandey
<click on below * if this helps>

[DexterG]

check the attachment... what if one number in a set (set of 3 numbers) is zero or -ve ?
Attachment 212193


Regards,
DILIPandey
<click on below * if this helps>

You are right, I've Attached a new sheet with corrections.
Sorry that was a mistake on my part.

Thank you very much.

[DexterG]

Copy of Number greater than zero(1).xlsx

check the attachment... what if one number in a set (set of 3 numbers) is zero or -ve ?
Attachment 212193


Regards,
DILIPandey
<click on below * if this helps>

You are right, I've Attached a new sheet with corrections.
Sorry that was a mistake on my part.

Thank you very much.