Ok. I have a Spreadsheet with Dates going across the columns (as headers) for a given month. The left most column (A) has time of day and the data is the number of phone calls that come in at that respective hour, on a given day.

I need to average the number of calls that come in on a particular day and hour. I'll want to evaluate average call volume for Monday at 6am, Tuesday 6am, etc. So for example:

Dec 1 Dec 2 Dec 3
6 am 8 4 2
7 am 2 9 15

I've been trying to put together an AverageIf function that uses the Date Range as the Range, Weekday = 2 (for Monday), and then averages the calls across the whole month. It's not working as planned and I have tried to use the Array { } quotes, too.

Can anyone tell me what a better function to use would be?

thanks.

The function you want is AVERAGEIFS, not AVERAGEIF.

Use the multiple criteria to set >= and <= ranges.