Try the following formula instead...

=IF(INDEX(FREQUENCY((F35:F38,F42:F45,F48:F54),0),2 ),AVERAGE(IF((1-ISNUMBE
R(MATCH(ROW(F35:F54)-ROW(F35)+1,{5,6,7,12,13},0)))*(F35:F540),F35:F54) ),
"")

....confirmed with CONTROL+SHIFT+ENTER, not just ENTER. Does this help?

In article ,
"Coal Miner" wrote:

Domenic,

Thanks alot. That did fix the problem when none of the target cells
contained a value greater than zero. However, I am still getting the #DIV/0!
error in some cells. I checked to make sure formatting was correct. I
removed the "1-" portion of the formula (located immediately prior to
ISNUMBER) and this allows the formula to work in the cells that were
returning the #DIV/0!. But, that formula will now return the #DIV/0! error
in the other cells that were working correctly. What is the purpose of the
"1-" text within the formula. Maybe if I understand that I could repair
myself.

Please help as this is frustrating.