| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Total the sum in a cell
I need to get the total sum from B1:B26 and get it to total in B27. What is
the formula? |
|
#2
|
|||
|
|||
|
Hi Misty
a copy of options in cell B27 type =SUM(B1:B26) or click in cell B27 and click the autosum icon on the toolbar (the funny E shaped one) Cheers JulieD "Misty" wrote in message ... I need to get the total sum from B1:B26 and get it to total in B27. What is the formula? |
|
#3
|
|||
|
|||
|
=SUM(B1:B26)
Regards, Peo Sjoblom "Misty" wrote: I need to get the total sum from B1:B26 and get it to total in B27. What is the formula? |
|
#4
|
|||
|
|||
|
=SUM(B1:B26) in cell B27
-- HTH RP (remove nothere from the email address if mailing direct) "Misty" wrote in message ... I need to get the total sum from B1:B26 and get it to total in B27. What is the formula? |
|
#5
|
|||
|
|||
|
I see you got some nice answers to your difficult question. Had you
considered going to HELP index and typing in the word sum -- Don Guillett SalesAid Software "Misty" wrote in message ... I need to get the total sum from B1:B26 and get it to total in B27. What is the formula? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| total same cell in all worksheets | Excel Worksheet Functions | |||
| Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
| how do i set up a single cell continual entry in excel to total f. | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
| VLookup resulting in a blank cell... | Excel Worksheet Functions | |||
Linear Mode
