FORMULA - COUNTIF WITH 2 ARGUMENTS

Katrina Savage

Hi,

In sheet summary I am trying to count total number of 'EVENT CATEGORY' that is 'STATUS'

The formula I have tried is =COUNTIF([Event category]:[Event category], "Webinar" [status]:[status], "complete")

Both columns are dropdown single select if that makes any difference. I am able to count by event category but adding the second criteria isn't working for me - I'm sure this is probably something simple, can anyone help?

Thanks,

Katrina

John Jonassen

I think you are almost there @Katrina Savage

Try this:

=COUNTIFS([Event category]:[Event category], "Webinar", [status]:[status], "complete")

(updated to change to COUNTIFS and added the comma in between "Webinar" and [status]:[status])

John Jonassen

I think you are almost there @Katrina Savage

Try this:

=COUNTIFS([Event category]:[Event category], "Webinar", [status]:[status], "complete")

(updated to change to COUNTIFS and added the comma in between "Webinar" and [status]:[status])

Katrina Savage

Yes it works!! Thank you for taking the time to respond!