| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I average cells
I need a formula to average cells only if there is a number in a cell.
Example in cell A1, A2,A3 A4 they all have a formulasand all 4 cells say 0.00 in cell A5 i have =average(A1:A4) So if I put 100 in cell A1 then my answer in cell A5 says 25 I Would like it to say 100 only average if the number is higher that 0.00 Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| from a group of cells.find average of cells containing values | Excel Discussion (Misc queries) | |||
| Excel-only average cells if two cells in same row, meet two condit | Excel Worksheet Functions | |||
| average cells, show 0 if nothing to average | Excel Discussion (Misc queries) | |||
| average 2 cells (Mileage Divide by Gallons in two cells | Excel Discussion (Misc queries) | |||
| Average Cells above 0 | Excel Discussion (Misc queries) | |||
Threaded Mode
