Thread
:
formula on counting
View Single Post
#
2
Posted to microsoft.public.excel.misc
Don Guillett
Posts: n/a
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!
Reply With Quote