What formula should I use? SUMIF or COUNT IF?

I am trying to come up with a formula to separate vehicle mileage by fiscal year and by tag number. Would this be a SUMIF or COUNTIF formula? I'm having a hard time coming up with the appropriate criteria.

I have this so far, but it doesn't work: SUMIF ([Fiscal Year], if [Tag Number]1@row="__", sum[Miles Driven]1@row "__")

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!