How do I count in column A when it meets all criteria in three col
 

Here's my example:
Column A Column B Column C
2 North Donna 09/26/06
3 South Abby
4 North Donna
5 North Donna
6 North Abby
7 North Cindy 09/01/06

I want to count column A when column C is blank, column B is Donna, and
column is North. The answer would be two (2). Any help would be great!
Thanks!

How do I count in column A when it meets all criteria in three col
 

=SUMPRODUCT(--(C1:C6=""),--(B1:B6="Donna"),--(A1:A6="North"))
--
Allllen


"dereksmom" wrote:

Here's my example:
Col A Col B Col C
2 North Donna 09/26/06
3 South Abby
4 North Donna
5 North Donna
6 North Abby
7 North Cindy 09/01/06

I want to count column A when column C is blank, column B is Donna, and
column is North. The answer would be two (2). Any help would be great!
Thanks!

How do I count in column A when it meets all criteria in three col
 

Try...

=SUMPRODUCT(--(A2:A7="North"),--(B2:B7="Donna"),--(C2:C7=""))

Hope this helps!

In article ,
dereksmom wrote:

Here's my example:
Column A Column B Column C
2 North Donna 09/26/06
3 South Abby
4 North Donna
5 North Donna
6 North Abby
7 North Cindy 09/01/06

I want to count column A when column C is blank, column B is Donna, and
column is North. The answer would be two (2). Any help would be great!
Thanks!