Count # of items returned with multiple criteria


We need to count the number of items returned based on the following criteria:

ColumnA can be one of 3 options (Apple, Banana, Chocolate), but not the other 3 options (Donut, Eclair, Fruit).

ColumnB must be greater than April 1, 2023.

I have tried CountIfs, CountM, nested CountIfs, SumIfs, helper columns, etc. and I have reached that point where none of it makes sense anymore. Help!

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!