Hi!

Try this:

Entered as an array using the key combination of CTRL,SHIFT,ENTER:

How to enter an array formula:

http://cpearson.com/excel/array.htm

=AVERAGE(IF((I1:I4=11)*(J1:J4="DP"),N1:N4))

Better to use cells to hold the criteria:

A1 = 11
B1 = DP

=AVERAGE(IF((I1:I4=A1)*(J1:J4=B1),N1:N4))

Biff

"Todd" wrote in message
...
Column I J N
11 DP 3100
21 AF 10000
41 AF 8000
21 DP 12000
How do I get the average sale if column N=sale amount if I=11 and J=DP or
if
I=21 J=AF Average Sale=? Please help me.
Thanks
Todd