FORMULA - COUNTIF WITH 2 ARGUMENTS
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?
Help Article Resources
Check out the Formula Handbook template!