Sheet Summary Formula Count

Options

Hi I am trying to create another formula in a sheet summary that reflects orders from several years in the past and to count how many there were based on my orders column.

I have this formula in but it doesn't work.

=COUNTIFS([ORDERS]:[ORDERS]),"YES - 2017" [ORDERS:ORDERS],"YES - 2016")), [ORDERS:ORDERS],"YES - 2015)))

Any help is greatly appreciated.

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!