Hey Domenic,

How about this, courtesy of Bob:<bg

=SUM(SUMIF(INDIRECT({"N3:N6650","P3:P6650"}),".01 ")-SUMIF(INDIRECT({"N3:N66
50","P3:P6650"}),"=.3"))/SUM(COUNTIF(INDIRECT({"N3:N6650","P3:P6650"}),".0
1")-COUNTIF(INDIRECT({"N3:N6650","P3:P6650"}),"=.3"))

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Domenic" wrote in message
...
Of the two formulas I offered, neither one provided you with the desired
result? If not, can you provide a small sample of your data, about 5
rows, along with your expected result?

In article ,
Deb Pingel
wrote:

We are trying to get an Average between 2 columns that have the same
conditions. We have been using an array formula succesfully on data
that is on 1 column and I have trying to incorporate an Offset into the
formula with no luck.
Here is our latetest attempt, WITHOUT THE OFFSET.
The data is in Column P and Column N

=AVERAGE(IF((('Mill Process Data'!N3:N6650,'Mill Process
Data'!P3:P6650.01)*('Mill Process Data'!N3:N6650,'Mill Process
Data'!P3:P6650<.3))*(ISNUMBER('Mill Process Data'!N3:N6650,'Mill
Process Data'!P3:P6650)),Mill Process Data'!N3:N6650,'Mill Process
Data'!P3:P6650)))

Thanks advance
Deb