About using COUNTIFS formula

Welcome to the New Smartsheet Online Community

You’ll notice that things have changed a bit. If you need help getting oriented, please take a look at the posts here in the Welcome to the Community category.

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

  • Accepted Answer

    Awesome, thanks for your help Paul.


Sign In or Register to comment.