Issue with CountIFs function

Earl P

Hi all i'm currently attempting to use a COUNTIF function to count with 3 conditions. However my output comes up with 0 when there are more than 0 items that meet the criteria. Can anyone assist to see if my formula is incorrect?

=COUNTIFS({Type}, HAS({Type}, "Storyline"), {Current Maintenance Assignee}, "Earl Prentice", {Production Status}, "Live")

Dale Murphy

@Earl P

I don't think you need the HAS clause. Try COUNTIFS({Type}, "Storyline", {Current Maintenance Assignee}, "Earl Prentice", {Production Status}, "Live")

Or, replace HAS({Type} with HAS(@cell) - that also seems to work but is more complicated.

dm