Using MIN, MAX and COUNTIF on ranges populated by formulas

Hi,
please post a sample file. see instructions at the top of the page on "HOW TO ATTACH YOUR SAMPLE WORKBOOK"

I would if i could, even my small sample version is 5MB, way over the allowable upload size.

I discovered i had left some linked formulas in the example, thats why my file size was so big. I brought it down to just values besides the formulas that i am having trouble with. All of the values on the Results tab are populated by index/match formulas looking through a large dataset, but i removed those formulas for now.

The hours in your file were texts. I changed them in number and formatted as H: mm: ss

HC Data

C2=IF(A2<>"",MINIFS(Result!$T$4:$T$21,Result!$P$4:$P$21,'HC Data'!$A2,Result!$S$4:$S$21,'HC Data'!$B2),"")

Copy down

Thank You CARACALLA, This formula works on the sample, in which the times are just values. In the full version of this workbook they are populated by an INDEX/MATCH formula. I have changed every instance of the times (on the raw data, the INDEX/MATCH formula and the report MINIFS formula) to the h:mm:ss format. It is still returning 0:00:00.

Attach real file with index match formula

I have added a minimized version of the raw data and the index/match formulas that extract the dates and times to my original post.

Pack time column D lookups sheet is a text

if you change the formula to D2 = IFERROR (INDEX ('Raw Data'! E: E, MATCH (Lookups! A2, 'Raw Data'! A: A, 0)) + 0, "")

copy down

transform from text to number and everything works


Sorry for my English