Count

[glen.e.mettler]

Using 2003 - I need to count values in one row based on the value in
another row.
Example
I have row 2 that shows C G C G C G etc (stands for Contractor,
Government)
in row 3 I have Y Y N Y N N etc (yes or no)

On the same row with Y & N I have columns for Con and Gov
In the Con column for row3 I need to count the number of N values for
C
In the Gov column for row3 I need to count the number of N values for
G

The COUNTIF function doesn't allow for multiple criteria
=Countif(C3:J3="N" and C2:J2="C") - doesn't work

How can I do this?

Glen

 

[Bob Phillips]

=SUMPRODUCT(--(C2:J2="C"),--(C3:J3="N")

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)