Countif function for specified date...

I'm trying to write a countif function (among others) that will go into another sheet and find a column by a specified date and count based on whether there is number there or not. Basically I just need to know how many funds have reported in that specified period. In my spreadsheet specifically, I need the formula to be based off the date in row 18 because the date is going to change from month to month.

In cell D15, I need to count in the "data compilation" tab how many non-blank values there are for November 2014 as a specific instance. In D16 & D17 I'm going to find the Max and Min respectively for that time period.

Thanks in advance.

Try

=COUNT(INDEX('Data Compilation'!$F$3:$AA$421,0,MATCH(D$18,'Data Compilation'!F2:AA2,0)))


You can just change COUNT to MIN and MAX for the other 2 cells.

Perfect, thanks!

If I wanted an AverageIf function for cell D19 where it averages all of the values for the date that have a sub-strategy (column c in "data compilation") equal to D19... Can you help with that?

Thanks

Try

=AVERAGEIF($C$4:$C$421,D19,INDEX('Data Compilation'!$F$3:$AA$421,0,MATCH(D$18,'Data Compilation'!F2:AA2,0)))