Thread: Conditional Average (2 conditions)
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kayard kayard is offline
external usenet poster
  
Posts: 1
Default Conditional Average (2 conditions)

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

Reply With QuoteReply With Quote