I have a spreadsheet where I cannot use macros or VBA, so I am limited to formulas.
I have a list of times and days of the week.
I need to count the number of rows where the number in column D is not below 00:15:00 and this works:
= countif(D:D,">=00:15:00")
I also need to find the highest number in row D in the rows where the weekday (in column F) is the same as shown in a nearby cell (H25). This works:
= {max(if(F:F=H25,D:D,""))}
NOTE that the {} show that the internal "if" statement returns an array from which the max calculates
Now, I need to find the number of rows where the number in column D is not below 00:15:00 AND the weekday in column F is the same as shown in a nearby cell (H25).
I thought this would work:
={countif((if(F:F=H25,D:D,"")), ">=00:15:00")}
The thinking was that the internal "if" statement is the same as in the max formula above, so it would return an array, which the countif could use to check against the ">=00:15:00" that works in the first "countif" statement.
But it doesn't work. Any help would be appreciated.
I have a list of times and days of the week.
I need to count the number of rows where the number in column D is not below 00:15:00 and this works:
= countif(D:D,">=00:15:00")
I also need to find the highest number in row D in the rows where the weekday (in column F) is the same as shown in a nearby cell (H25). This works:
= {max(if(F:F=H25,D:D,""))}
NOTE that the {} show that the internal "if" statement returns an array from which the max calculates
Now, I need to find the number of rows where the number in column D is not below 00:15:00 AND the weekday in column F is the same as shown in a nearby cell (H25).
I thought this would work:
={countif((if(F:F=H25,D:D,"")), ">=00:15:00")}
The thinking was that the internal "if" statement is the same as in the max formula above, so it would return an array, which the countif could use to check against the ">=00:15:00" that works in the first "countif" statement.
But it doesn't work. Any help would be appreciated.
