Hello!
I have slammed my head on this one for a while now! This formula should work, but there is clearly a detail I am missing, as it is pretty straight forward.
The attached sheet is edited (removed sensitive data), but has the essentials. Passdown tab contains the formula with the error, with the other tabs feeding data across the sheet.
Referencing the Report tab, Passdown tab is trying to get an average of Turnaround time for samples a technician (from Personnel tab) has processed, based on the request priority level, and number of samples processed (see attachment). I am using:
=AVERAGEIFS(Report!$H:$H,Report!$C:$C,Personnel!$A2:$A30,Report!$D:$D,$C6,Report!$G:$G,D$5,Report!$H:$H,"")
It should return the time based on previous experience using the code with other reports, but it is returning #Div/0! instead. I need it to return the average time based on the parameters referenced.
Anyone notice something that I missed?
Bookmarks