| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subtotal Function is Inconsistent
Thanks.
"Sandy Mann" wrote: Use =SUBTOTAL(9,A1:C1) etc in place of SUM(), this's what it is designed for. -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "TKS_Mark" wrote in message ... I'm using =SUBTOTAL(9,A8:IU8) on a large row of cells. This large row of cells contains many sum functions. On some spreadsheets, the subtotal only counts the sum cells. On others, it counts everything. How can I control this? Paste the following into cell A1 of a blank spreadsheet. All of the below should be on the same row. 1 5 6 =SUM(A1:C1) 3 9 2 =SUM(E1:G1) =SUBTOTAL(9,A1:H1) Shouldn't cell I1 = 26 instead of 52? I know it works sometimes. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Subtotal Function | Excel Discussion (Misc queries) | |||
| SubTotal Function | Excel Discussion (Misc queries) | |||
| IF function comare to identical amount but inconsistent results | Excel Worksheet Functions | |||
| Embed a countif function in subtotal function? | Excel Worksheet Functions | |||
| How do I nesting subtotal function within average function in Exc | Excel Worksheet Functions | |||
Threaded Mode
