COUNTIF function

P

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
 
Top