Average Selected Cells From a Range
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.
|