Compare 2 Columns and get a count

I need a formula that will count up how many people meet certain criteria based on specific information in 2 different columns.

Jack

Try the following...

=SUMPRODUCT(--(Range1=Cond1),--(Range2=Cond2))

Hope this helps!

Originally Posted by hilton

I need a formula that will count up how many people meet certain criteria based on specific information in 2 different columns.

Jack

That doesn't seem to work
Maybe I need to give you more information, the report asks for the number of single families at the beginning of the project year.

Col A Col B
Date Single/Family
1/1/05 s
1/10/05 s
1/1/05 F

So the answer should be 1.

Jack

Try the following...

=SUMPRODUCT(--(A1:A3="1/1/05"+0),--(B1:B3="s"))

OR

=SUMPRODUCT(--(A1:A3=C1),--(B1:B3=D1))

...where C1 contains the date of interest and D1 contains the status of interest.

Hope this helps!

Originally Posted by hilton

That doesn't seem to work
Maybe I need to give you more information, the report asks for the number of single families at the beginning of the project year.

Col A Col B
Date Single/Family
1/1/05 s
1/10/05 s
1/1/05 F

So the answer should be 1.

Jack