Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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". |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
match formula - 2 excel files:#1 hasthis formula, 2nd has the Raw | Excel Worksheet Functions | |||
Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
Converting an Excel formula to an Access query formula | Excel Discussion (Misc queries) |