Seeking Assistance - Average Days Open, by Status, Month/Year

GregLunaP20

Hi All - I'm trying to calculate the average # of days for data set, where the Status is "X", and the M/Y = "Y". I'm good with "AverageIf" = label@row, but not sure how I can incorporate the date piece. Thanks in advance!

Sharing some snapshots of the data, all columns (Total Days Open, Completion Status, Leave Blank...) are within same sheet. The "Total Days Open" is functioning fine, and should be used to calculate average against the status type and the Date MM/YYYY. Last image is how I record the metrics on a separate sheet.

Paul Newcome

Have you tried an AVG/COLLECT combo?

=AVG(COLLECT({Range To Average}, {1st Criteria Range}, 1st criteria, {2nd Criteria Range}, 2nd criteria))

GregLunaP20

I have not tried the 'collect' piece, I'll give that a try now. Thanks - I'll let you know.