formula on counting

M

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!
 
J

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
 
Top