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 "__")
Help Article Resources
Check out the Formula Handbook template!