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.
|