=AVERAGE(IF((NOT(ISNA(A1:A10)))*(B1:B10),A1:A10))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"kayard" wrote in
message ...

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

I need this to be made in one formula without adding any more column in
the sheet! is it possible ?

Thanks

Paolo


--
kayard
------------------------------------------------------------------------
kayard's Profile:
http://www.excelforum.com/member.php...o&userid=24716
View this thread: http://www.excelforum.com/showthread...hreadid=569791