| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing only #'s on unhidden columns
Assume cells B1, C1 and D1 have 5's in them and that I hide column C. I am
trying to figure out how to sum B1:d1 and get the answer 10. When I try to use the =subtotal(109,b1:d1) function it returns the answer 15. Subtotal(109,x:y) works to add only shown rows but it doesn't seem to work on column sums. Does anybody have a suggestion. Thanks Peter |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Summing columns | Excel Discussion (Misc queries) | |||
| summing columns | Excel Worksheet Functions | |||
| Summing Columns | Excel Worksheet Functions | |||
| Not summing a columns? | Excel Worksheet Functions | |||
| Hidden Columns are unhidden when inserting a Formula | Excel Discussion (Misc queries) | |||
Threaded Mode
