EXCEL FORMULA
 

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".

--
Message posted via http://www.officekb.com

EXCEL FORMULA
 

One way:

D16: =SUM(D1:D15)

In article <75e1b94985b63@uwe,
"poppiekat via OfficeKB.com" <u36195@uwe wrote:

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".

EXCEL FORMULA
 

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(D1:D15)

Rick

EXCEL FORMULA
 

JE McGimpsey wrote:
One way:

D16: =SUM(D1:D15)

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".
Thanks 1,000,000

--
Message posted via http://www.officekb.com

EXCEL FORMULA
 

Rick Rothstein (MVP - VB) wrote:
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(D1:D15)

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

--
Message posted via http://www.officekb.com

EXCEL FORMULA
 

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
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"poppiekat via OfficeKB.com" <u36195@uwe wrote in message
news:75e1b94985b63@uwe...
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".

--
Message posted via http://www.officekb.com