About using COUNTIFS formula


I am trying to use a COUNTIFS formula to identify the number of cells from a column ('Age Range') with a drop-down box with various options ('Under 18' / '18 o 30' / '30+') and are from a particular year in a 'YEAR' column. I know that this is fairly basic but I am a bit of a novas at formulas.

Cheers Peter

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!