Biff,
It appears that the elephant I saw was not the elephant you saw...
I saw the issue as: only average the data in B2:F2000 if every
cell in CJ2:CJ2000 has a 1 in it.
--
Jim Cone
Portland, Oregon USA



"T. Valko"
wrote in message
=AVERAGE(IF(Sheet1!CJ2:CJ2000=1,Sheet1!B2:F2000))
Array entered, worked just fine for me. Confirmation formulas also verified
the result was correct.
--
Biff
Microsoft Excel MVP


"Jim Cone" wrote in message
...
Biff,
I get 0 as a result when entered as an array formula.
However, this 'meat and potatoes' version seems to work...
=IF(AND(MAX(paste_data!CJ2:CJ2000)
=1,MIN(paste_data!CJ2:CJ2000)=1,COUNTBLANK(paste_d ata!CJ2:CJ2000)=0),AVERAGE(B2:F2000),"Don't
do
it")
--
Jim Cone
Portland, Oregon USA