Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Aug 2001
    Location
    Boston, Massachusetts, USA
    Posts
    167
    Thanks
    1
    Thanked 0 Times in 0 Posts

    DAVERAGE (Excel 2003 / SP1)

    I just can't figure out why DAVERAGE doesn't work like a vlookup or a sumif. My eyes are crossing. What am I missing?????
    thanks
    christine

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: DAVERAGE (Excel 2003 / SP1)

    DAVERAGE expects a criteria range that looks like that for Advanced Filter: field names in the first row, one or more rows with criteria below the field names. You cannot use it the way you're trying to do: you specify a data range with 5 columns (F:J) and want to calculate the average of the 6th column. <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

    Use the following array formula (confirm with Ctrl+Shift+Enter) in O11:
    <code>
    =IF(COUNTIF($F$2:$F$100,K11)>0,AVERAGE(IF($F$2:$F$ 100=K11,$J$2:$J$100)),"")
    </code>
    and fill down to O22.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •