Double Countif
Hi all. I need to do a 2 level countif. Given the following 3 column
example:
A 1 0
B 0 0
A 1 0
C 1 1
D 0 1
A 0 0
X 0 0
I need a formula at the bottom of each column that will count the number of
entries that are BOTH greater than zero AND have A in the forst column. So
the first numerical column result would be 2, the second would be 0.
Possible?
|