Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum/total
I've asked a few here about getting a sum... took a long time on my part but
found the sum icon and dragged it to my toolbar. When I highlighted the column cells I wanted to total all I got in the Total box/cell was the = mark with the parameters of the column's rows I had highlighted - of course included in the highlight was the total box/cell. I can't find a way to get TOTAL in that cell/box. Any ideas? Thanks guys. Bill |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum/total
Can you copy and past into this forum the cells that you are working with?
Do you want the word "TOTAL" in that cell? What exactly do you want as a result? "Bill" wrote: I've asked a few here about getting a sum... took a long time on my part but found the sum icon and dragged it to my toolbar. When I highlighted the column cells I wanted to total all I got in the Total box/cell was the = mark with the parameters of the column's rows I had highlighted - of course included in the highlight was the total box/cell. I can't find a way to get TOTAL in that cell/box. Any ideas? Thanks guys. Bill |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum/total
Thanks Brad,
Nope don't want the word Total... simply want the actual total... what shows up in the "total" cell is the formula, designating "= B4 and b23" (the cells I want a total in... the actual numbers go from B4 to B22... and can't get it to total the column. Thanks "Brad Vogt" wrote: Can you copy and past into this forum the cells that you are working with? Do you want the word "TOTAL" in that cell? What exactly do you want as a result? "Bill" wrote: I've asked a few here about getting a sum... took a long time on my part but found the sum icon and dragged it to my toolbar. When I highlighted the column cells I wanted to total all I got in the Total box/cell was the = mark with the parameters of the column's rows I had highlighted - of course included in the highlight was the total box/cell. I can't find a way to get TOTAL in that cell/box. Any ideas? Thanks guys. Bill |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum/total
"= B4 and b23" is a text string, not a formula.
If you want to total the values in the range, use =SUM(B4:B22) -- David Biddulph "Bill" wrote in message ... Thanks Brad, Nope don't want the word Total... simply want the actual total... what shows up in the "total" cell is the formula, designating "= B4 and b23" (the cells I want a total in... the actual numbers go from B4 to B22... and can't get it to total the column. Thanks "Brad Vogt" wrote: Can you copy and past into this forum the cells that you are working with? Do you want the word "TOTAL" in that cell? What exactly do you want as a result? "Bill" wrote: I've asked a few here about getting a sum... took a long time on my part but found the sum icon and dragged it to my toolbar. When I highlighted the column cells I wanted to total all I got in the Total box/cell was the = mark with the parameters of the column's rows I had highlighted - of course included in the highlight was the total box/cell. I can't find a way to get TOTAL in that cell/box. Any ideas? Thanks guys. Bill |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Duplicate Running Total Grand Total In Pivot Table | Excel Discussion (Misc queries) | |||
Excel 2002 : Any single button to get sub total and grand total ? | Excel Discussion (Misc queries) | |||
calculate count on 2006 total, 2005 total, etc... | Excel Worksheet Functions | |||
Pivots - Auto calc % Sub total is of grand total | Excel Discussion (Misc queries) | |||
Adding Data Using Multiple Worksheets to Total into a Grand Total | Excel Worksheet Functions |