Thread: Double Countif
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steph[_6_] Steph[_6_] is offline
external usenet poster
 
Posts: 92
Default 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?