View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default Average Selected Cells From a Range

=AVERAGE(IF(B6:R6="Y",B14:R14))

entered with ctrl + shift & enter

if B6:R6 can have Y and B14:R14 can be blank and you don't want count that
as 0

=AVERAGE(IF(B6:R6="Y",IF(B14:R14<"",B14:R14)))

also array entered



--
Regards,

Peo Sjoblom
'

"pdberger" wrote in message
...
Good morning --
I would like to average the values of cells B14:R14 if the corresponding
value in the range B6:R6 is "Y". I've searched these threads, tried
'sumproduct' and CSE formulas, but just can't quite get over the hump.
Any
assistance offered would be greatly appreciated.

Thanks in advance.