| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Division by zero in automated subtotals
What is the easiest way to division by zero errors that occur when using
automated subtotals to display averages? |
|
#2
|
|||
|
|||
|
Look for a count of numbers to be bigger than 0.
=IF(SUBTOTAL(2,A2:A10)=0,"",SUBTOTAL(1,A2:A10)) Neil Berkowitz wrote: What is the easiest way to division by zero errors that occur when using automated subtotals to display averages? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I copy an outline w/ subtotals & paste just the subtotals | Excel Discussion (Misc queries) | |||
| Excel gets subtotals out of order using multiple sorts and subtot. | Excel Discussion (Misc queries) | |||
| Subtotals | Excel Discussion (Misc queries) | |||
| Subtotals Problem when Filtering | Excel Discussion (Misc queries) | |||
| why are nested subtotals coming out below outer subtotals? | Excel Worksheet Functions | |||
Linear Mode
