Sorry, I meant Biff.
--
when u change the way u look @ things, the things u look at change.


"Biff" wrote:

Hi!

Try it like this:

=AVERAGE(IF((rng1=criteria1)*(rng2=criteria2)*(rng 3=criteria3)*(rng4=criteria4),rng_to_avg))

This is an array formula. It must be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER).

Biff

"sahafi" wrote in message
...
I have a 'Sumproduct' function working fine on my Excel file, but I need to
use similar method, this time to do the average instead of sum. I need to
evaluate about 4 criteria, then average the numbers from another column. I
know there's no such: AverageProduct function. I have tried to use the
Average(--(sheet1!$A$2:$A$10000=sheet2$M$8)*(sheet1!$B$2:$B$ 10000=sheet2$A11)-----*(sheet1!$I$2:$I$10000)).
The formula runs ok, but it gets only a value on one row instead of
averaging
out all the values on multiple rows.
Is there another way/function of doing this?
Any direction is very much appreciated.

Thanks.
--
when u change the way u look @ things, the things u look at change.