Mac Forum / Applications / Excel / November 2006

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

On 11/21/06 5:34 PM, in article
F4D43C8A-B237-4332-9F28-BCDF4B7C387F@microsoft.com, "sesler2"