DAVERAGE (Excel 2003 / SP1)

Topic

New Reply

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?????

Reply | Quote

Replies

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.

Use the following array formula (confirm with Ctrl+Shift+Enter) in O11:

=IF(COUNTIF($F$2:$F$100,K11)>0,AVERAGE(IF($F$2:$F$100=K11,$J$2:$J$100)),"")

and fill down to O22.

Reply | Quote