YEP ... and it's less then Half the size too.<g

--

Regards,

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

"Domenic" wrote in message
...
Here's another alternative...

=AVERAGE(IF(MOD(COLUMN(N3:P6650)-COLUMN(N3),2)=0,IF(N3:P66500.01,IF(N3:P
6650<0.3,N3:P6650))))

....confirmed with CONTROL+SHIFT+ENTER.

In article ,
"RagDyer" wrote:

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