Ask Experts Questions for FREE Help !
Ask
    jakester's Avatar
    jakester Posts: 582, Reputation: 165
    Senior Member
    		  
    #1

    Nov 30, 2010, 08:33 AM
    AverageIf Function?
    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.
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #2

    Nov 30, 2010, 11:23 AM

    The function you want is AVERAGEIFS, not AVERAGEIF.

    Use the multiple criteria to set >= and <= ranges.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search


Check out some similar questions!

Function e^x [ 2 Answers ]

dear sir , I'm asking about the table of variation for function ( e^2x - 3.e^x +2) / ( e^2x + 3.e^x - 4 ) and I need the shape of graph representing this function

The result of increasing and decreasing function on the composite function [ 6 Answers ]

I was asked to prove the result of increasing and decreasing function on the composite function... prove that: 1- if f(X) inc & g(X) inc, foG inc 2-if F(X) inc & G(X) dec, foG dec 3- if F(X) dec & G(X) inc, fog dec 4- if f(X) dec & G(X) dec, fog inc please help me in that

Function Or Not? [ 1 Answers ]

Tell whether or not the pairing is a function Input Output 9 0 8 2 7 4 7 6 I think it is I'm just not sure it's the 2 sevens that Are really bothering me if someone can help id...

TV Out Function On [ 0 Answers ]

I've got a DVD drive and the PowerDVD 5.0 player and every time I try to watch a newer DVD, I get the error message "TV out function error", I look at the details and it says I can't play copyright protected DVD's with the TVout function enabled. The weird thing is, ALL my graphics adapters just...

View more questions Search