Hello,
I would like to calculate the max and min of a row of numbers, while excluding those numbers that correspond to a date range
Row 3, or range C3:JO3 is the row with ALL the dates
tab excludelist, range $AF$84:$AF$95 is the range of dates that I want to exclude from the max/min calculation
C186:JO186 is the row that the calculation is based upon.
I thought I had this, but the more I google, the more confused im getting.
I don't understand what I am missing in the below?
=MIN(IF(C3:JO3<>'excludelist'!$AF$84:$AF$95,C186:JO186)
I would like to calculate the max and min of a row of numbers, while excluding those numbers that correspond to a date range
Row 3, or range C3:JO3 is the row with ALL the dates
tab excludelist, range $AF$84:$AF$95 is the range of dates that I want to exclude from the max/min calculation
C186:JO186 is the row that the calculation is based upon.
I thought I had this, but the more I google, the more confused im getting.
I don't understand what I am missing in the below?
=MIN(IF(C3:JO3<>'excludelist'!$AF$84:$AF$95,C186:JO186)