Formulas
 

I have two columns with multiple entries, I need to count how many entries
are for records that contains a criteria, but if I use COUNT(IF(...)) it
seems that is counting only the first line. How can I do it?

Formulas
 

Hi Monerva

You need to use COUNTIF(data_range,criteria)

HTH
Ed


--
EdMac
------------------------------------------------------------------------
EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736
View this thread: http://www.excelforum.com/showthread...hreadid=538992