IF AND FORMULA CROSS REFERENCING ANOTHER SHEET

Fialko66

Sorry folks, me again

I am trying to get and if and formula to work that references values in another sheet but keep getting 'INCORRECT ARGUMENT SET'

I can get both parts to work separately but cannot get them to combine to give a single result

part one works ok =COUNTIF({0-5 IMMSUNISATIONS Range 2}, =0)

part two works ok =COUNTIF({0-5 IMMSUNISATIONS Range 3}, ="DATES MISSING")

But this doesn't work at all. I could cheat and use the 2 helper columns in the destination cheat that do work and just take one away from the other but i'd rather have it all in one formula and it be cleaner

=COUNTIF(AND({0-5 IMMSUNISATIONS Range 2}, =0, {0-5 IMMSUNISATIONS Range 3}, ="DATES MISSING"))

Paul Newcome

You need a COUTNIFS (with the "S" on the end) to be able to use multiple range/criteria sets. You would also need to get rid of the AND function as it is "built in" to the COUNTIFS.