I need to get the total sum from B1:B26 and get it to total in B27. What is the formula?
M Misty Feb 1, 2005 #1 I need to get the total sum from B1:B26 and get it to total in B27. What is the formula?
J JulieD Feb 1, 2005 #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
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
B Bob Phillips Feb 1, 2005 #4 =SUM(B1:B26) in cell B27 -- HTH RP (remove nothere from the email address if mailing direct)
D Don Guillett Feb 1, 2005 #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
I see you got some nice answers to your difficult question. Had you considered going to HELP index and typing in the word sum