| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subtotal across a row
I understand that subtotal 101 calculates an average of cells in a column
without counting the hidden rows. Is there a comparable method to calculate the average of cells in a row without counting the hidden column values? Goody |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Subtotal across a row
As I explained in your identical post of a couple of hours ago, there is no
direct function in Excel to do this. Did you try the method I gave your here http://www.microsoft.com/office/comm...f-5d303366c788 -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Goody" wrote: I understand that subtotal 101 calculates an average of cells in a column without counting the hidden rows. Is there a comparable method to calculate the average of cells in a row without counting the hidden column values? Goody |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Subtotal To Include Item Description On Subtotal Line | Excel Discussion (Misc queries) | |||
| sort macro, subtotal and add lines after subtotal | Excel Discussion (Misc queries) | |||
| pasting to subtotal lines without replacing hidden -non-subtotal l | Excel Discussion (Misc queries) | |||
| Bolding the subtotal lines automaticlly When using the Subtotal fu | New Users to Excel | |||
| Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
Linear Mode
