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)

--
Don Guillett
SalesAid Software
[email protected]
"Michael A" <[email protected]> wrote in message
news:[email protected]...
> 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!
>
>

[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