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
--
Deb Pingel
------------------------------------------------------------------------
Deb Pingel's Profile:
http://www.excelforum.com/member.php...o&userid=20119
View this thread:
http://www.excelforum.com/showthread...hreadid=498843