Averaging values with condtions for several columns

[sesler2]

I have 3 columns within my spreadsheet of 233 rows:

Work Group - either AAA or BBB
Finance Value - ranging from $0 to $1.5 million
Delivery Time - ranging from 0 to 500 (days)

I want to find the average delivery time for each group where finance value

$0.2m and again where finance value <= $0.2m. I have been sorting by group

then finance value and manually average the rows when those values fall but
there must be an easier way. Have looked at sumproduct but I need averages.

 

[CyberTaz]

One option - although there are probably a number of others - would be to
use the DAVERAGE fx. Copy your Work Group & Finance Value captions to
another location (the example below uses E7:E8). Those two cells plus the
two immediately below them create a Criteria Area. Put AAA in cell E8,
<=1200000 in cell F8, and in another cell enter the following function
(assumption that the data range is A1:C234 and the values to be averaged are
in column C;

=DAVERAGE($A$1:$C$234,$C$1,$E$7:$F$8)

The result will be the average Delivery Time for AAA Work Group with Finance
Value <=1.2m based on the criteria in the Criteria Area. To find other
results just change the criteria in cells E8 and/or F8 and the fx will
update. Bonus: Sort order doesn't matter But if you intend to use Filters
on the list, make sure to not put the Criteria Area & fx in the same rows as
the list - you won't be able to see results when rows are collapsed.

HTH |:>)
Bob Jones
[MVP] Office:Mac