| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autopilter
How do i get the sum of a exel sheet that is filterd by autofilter. I only
want to calculate the valuse that i see on the display, but SUM calculatse every value from the list even when i am using autofilter. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Autopilter
Hi,
look in help for SUBTOTAL and you will see how to some visible rows in a filtered range. Mike "charli" wrote: How do i get the sum of a exel sheet that is filterd by autofilter. I only want to calculate the valuse that i see on the display, but SUM calculatse every value from the list even when i am using autofilter. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
