| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Average in Cells
I know how to calculate the Average within a range of cells - however, what I would like to do is calculate the average but for only those cells that return a figure based on the results of another formula - example:if you have 6 cells but only 3 cells return a value, I would like the average calculated on the 3 cells and not based on 6 - and similarly, if another 2 figures are entered, the formula then calculates the average of the 5 figures - hope this makes sense. -- martins ------------------------------------------------------------------------ martins's Profile: http://www.excelforum.com/member.php...o&userid=31616 View this thread: http://www.excelforum.com/showthread...hreadid=526065 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumif Cells Are Not Blank | Excel Worksheet Functions | |||
| 30 Day Moving Average Ignoring Blank Cells | 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 | |||
| How do i get an average that ignores blanks in the range of cells. | Excel Worksheet Functions | |||
Threaded Mode
