formula on counting
 

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!

formula on counting
 

try

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

--
Don Guillett
SalesAid Software

"Michael A" wrote in message
...
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!

formula on counting
 

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


--
JAVB
------------------------------------------------------------------------
JAVB's Profile: http://www.excelforum.com/member.php...o&userid=29304
View this thread: http://www.excelforum.com/showthread...hreadid=498706