Hello All,
How do I set the criteria for an AverageIF formula to pull all records in column B:B that are =March. Format of B:B is m/dd/yyyy
Hello All,
How do I set the criteria for an AverageIF formula to pull all records in column B:B that are =March. Format of B:B is m/dd/yyyy
With AVERAGEIF (and others like SUMIF, COUNTIF etc.) you can't manipulate the range, so it would be better to use AVERAGEIFS so you can use 2 conditions:
=AVERAGEIFS(average_range,B:B,">="&DATE(2013,3,1),B:B,"<"&DATE(2013,4,1))
i.e. greater than or equal to 1st March 2013 AND less than 1st April 2013.
Hope this helps.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks