COUNTIF function

[Pauline]

Hello,
I'm trying to use a compound function to count cells that
match certain data. Example:
=COUNTIF(E1:E100,"JOHN DOE") and COUNTIF(J1:J100,"H")

Can someone help me figure this formula?

Thanks!
Pauline

 

[Starwing]

http://www.j-walk.com/ss/excel/tips/tip52.htm

Starwing

 

[Frank Kabel]

Hi
=SUMPRODUCT(--(E1:E100="JOHN DOE"),--(J1:J100="H"))

 

[Pauline]

You guys are absolutely AWESOME!

-----Original Message-----
Hi
=SUMPRODUCT(--(E1:E100="JOHN DOE"),--(J1:J100="H"))

.