a friend has suggested a COUNTIFS formula, but i'm unsure on how, any ideas??
+============+
OK, update so far, i can get the sheet to show how how many times the set area shows up, im now struggling with showing a total of hours for each area.
=COUNTIFS($E:$E,$AQ$3,$L:$L,"AREA1")
this shows me how many times, now all i want is to add up the total hours for each area, so i have attempted to duplicate the formula with
=SUMPRODUCT(--($E:$E=$AV$3),--($L:$L=$AR$2),$AK:$AK)
Yet this does not add up the hh:mm accurately.
What am i missing please?
Bookmarks