FORMULA - COUNTIF WITH 2 ARGUMENTS

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

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!