![]() |
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? |
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? |
=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? |
=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? |
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