EXCEL FORMULA

[poppiekat via OfficeKB.com]

IN AN EXCEL SPREAD SHEET, WHAT FORMULA WOULD I USE IF I NEED A TOTAL AT THE
BOTTOM OF A COLUMN OF 15 NUMBERS? In other words, I have 15 rows with a
number in column "D" for each row and I need a total in row 16 of this column
"D".

 

[JE McGimpsey]

One way:

D16: =SUM(D115)

 

[Rick Rothstein \(MVP - VB\)]

IN AN EXCEL SPREAD SHEET, WHAT FORMULA WOULD I USE IF I NEED A TOTAL AT

THE
BOTTOM OF A COLUMN OF 15 NUMBERS? In other words, I have 15 rows with a
number in column "D" for each row and I need a total in row 16 of this
column
"D".

Try this...

=SUM(D115)

Rick

 

[poppiekat via OfficeKB.com]

One way:

D16: =SUM(D115)

Thanks 1,000,000

 

[poppiekat via OfficeKB.com]

Try this...

=SUM(D115)

Rick

Thanks 1,000,000
As you can see, I'm a babe in the woods on this Excel.
Appreciate your patience.

 

[Bernard Liengme]

While we are all happy to help, I do urge you to think about a cheap book
(like Excel for Dummies - maybe a used one from www.abebooks.com ). You will
get so much more out of Excel if you master the basics and learn the right
terms to ask questions
all the best in you endeavours