ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Total the sum in a cell (https://www.excelbanter.com/excel-discussion-misc-queries/10962-total-sum-cell.html)

Misty

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?

JulieD

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?




Peo Sjoblom

=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?


Bob Phillips

=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?




Don Guillett

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?





All times are GMT +1. The time now is 04:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com