Need to sum numbers from a metric sheet to a rollup sheet for specific quarters/year
Is it possible to use a formula to sum the total of a column that meet a criteria? I'm trying to create a rollup sheet (from the data sheet) based on year/quarter. So I'd like to be able to use a formula. I need this to look at the Year and Quarter column as the criteria before it adds the other column together.
I've attached screenshots of my basic rollup sheet. I'm trying to find a way to do this without having to revisit and manually add in items.
Any help would be appreciated.
Help Article Resources
Check out the Formula Handbook template!