I'll try to explain better.

I have in A1:A100 either numbers or #N/A. In B1:B100 there is eithe
TRUE or FALSE. I want to calculate the average of A1:A100 but only o
those rows where there is an actual number (Not #N/A) and wher
condition in column B is true.

Thank

--
kayar
-----------------------------------------------------------------------
kayard's Profile: http://www.excelforum.com/member.php...fo&userid=2471
View this thread: http://www.excelforum.com/showthread.php?threadid=56950