| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
omiting cells in average calcs
how do i calculate average of cells but only if certain cells say something.
ex: average of cells A1,A11,A12,A14. average of those cells but for cell A14 only include it in the average calculation if cell A13 has "x". if "x" is not present in cell A13 then only calculate the average of A1,A11,A12 & omit results of cell A14. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumif Cells Are Not Blank | Excel Worksheet Functions | |||
| Average function with #VALUE! error in reference cells | Excel Worksheet Functions | |||
| Limit or Exclude cells in Average and Sum formula | Excel Worksheet Functions | |||
| average cells omitting nulls | Excel Worksheet Functions | |||
| How do i get an average that ignores blanks in the range of cells. | Excel Worksheet Functions | |||
Threaded Mode
