Hello
I'm having trouble getting a formula to return the average date instead of its sum.
=SUMPRODUCT(SUMIFS(INDIRECT("'"&F2:F58&"'!C3:C338"),INDIRECT("'"&F2:F58&"'!I3:I338"),"*"&A2&"*"))
I have 57 sheets which I'm using the INDIRECT formula to capture each sheet. After that I'm selecting my dates column (C) then filteringf for my criteria (I). Lastly my Criteria is (A2).
I know the formula is capturing the correct dates matching with the criteria I selected because when I manually select them to view the average in the bar next to the zoom, I see the average and the sum, with the sum matching what I get.
I'm having trouble getting a formula to return the average date instead of its sum.
=SUMPRODUCT(SUMIFS(INDIRECT("'"&F2:F58&"'!C3:C338"),INDIRECT("'"&F2:F58&"'!I3:I338"),"*"&A2&"*"))
I have 57 sheets which I'm using the INDIRECT formula to capture each sheet. After that I'm selecting my dates column (C) then filteringf for my criteria (I). Lastly my Criteria is (A2).
I know the formula is capturing the correct dates matching with the criteria I selected because when I manually select them to view the average in the bar next to the zoom, I see the average and the sum, with the sum matching what I get.