Formula assistance Request- how to count total hours

jcharger13

Trying to pull total hours from one sheet for each QTR and total them on a metric sheet.

This is from the data sheet:

I want to total it here:

VBAGuru

You should use the Sumifs formula. For your first cell, you could use a similar formula to below, but you will need to map the ranges to the data sheet. By using the @row, you can just copy the formula down and down't have recreate it so many time.

=Sumifs({Data Sheet Hours},{Data Sheet QTR},[Metric Sheet Qtr]@row,{Data Sheet Lead Category},"Lead Call")