EXCEL FORMULA

  • Thread starter Thread starter poppiekat via OfficeKB.com
  • Start date Start date
P

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".
 
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".
Click to expand...

Try this...

=SUM(D1:D15)

Rick
 
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
 
Back
Top