Formulas

[monerva]

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?

 

[EdMac]

Hi Monerva

You need to use COUNTIF(data_range,criteria)

HTH
Ed