Multiple Criteria, total count


Hi All,

I am trying to do calculate a total number of events, that match criteria for 1. Date range (can also use fiscal column as a matching criteria where i only want those that contain specific letter/numerical value = Q2) for all -NDA Webinars. I don't want it to count each column that matches the criteria, but if the two criteria match, i want it to count as 1 event. Does that make sense?

I have tried countifs and sumifs, and cannot seem to make it work. Can someone suggest a formula?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!