formula on counting

[Michael A]

Hello, could someone please help me with a forumula. Im not sure what
function to use to get this to work right.

I need a formula that will count how many entries in column C say "CXL". But
I only want it to count on the rows that have "John" in column A. Im not sure
how to do this. Thanks!

 

[Don Guillett]

try

=sumproduct((a2:a22="John")*(c2:c22="cxl")*1)

 

[JAVB]

Try the formula =SUMPRODUCT((B3:B20="John")*(C3:C20= "CXL"))
Column B being a list of names and column C being a list of string
letters.
You can also use named ranges in place of the cell references.

JAVB