| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I get a formula to work on visible cells with autofilt
Perfect - exactly what I was looking for. Thanks!
Jude "Ardus Petus" wrote: Look in Help at SUBTOTAL HTH -- AP "Jude Sweeney" <Jude a écrit dans le message de news: ... I have a worksheet that has data for new items, repaired items, and some with no values. I use autofilter to select only the rows for the repaired items, and I want to do an average of these items only. when I put the funtion in, it selects every row, rather than only the visible ones. Short of having to click through each individual row for the average, is there an easy way to do this? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| Why does this Formula work? | Excel Worksheet Functions | |||
| Help to adapt Formula syntax to work with Visible Filtered Cells | Excel Worksheet Functions | |||
| tried using SUBTOTAL function (XL XP) and it doesn't seem to work | New Users to Excel | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
Threaded Mode
