| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Average range including blank cells: #DIV/0! | Excel Worksheet Functions | |||
| How do I average a range of cells when one cell contains #N/A | Excel Discussion (Misc queries) | |||
| How can i put a negative sign on a range of selected cells? | Excel Discussion (Misc queries) | |||
| Automatically clear values from a range of selected cells | Excel Discussion (Misc queries) | |||
| How do I merge in a selected range of cells out of Excel? | Excel Discussion (Misc queries) | |||
Threaded Mode
