Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
HOW DO I ADD
I'M REAL NEW TO EXCEL.....
I NEED TO ADD D11 + D12 + D13+ D14+ D15 + D16 + D17 WITH THE ANSWER IN D19 I'VE BEEN WORKING FOR ABOUT 1 HR. AND STILL IT DOES NOT ADD UP NO TOTAL IN D19......HELP....THANK YOU.... -- CHEROKEE |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
HOW DO I ADD
Enter this formula in D19:
=SUM(D11:D17) -- Biff Microsoft Excel MVP "CHRIS" wrote in message ... I'M REAL NEW TO EXCEL..... I NEED TO ADD D11 + D12 + D13+ D14+ D15 + D16 + D17 WITH THE ANSWER IN D19 I'VE BEEN WORKING FOR ABOUT 1 HR. AND STILL IT DOES NOT ADD UP NO TOTAL IN D19......HELP....THANK YOU.... -- CHEROKEE |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
HOW DO I ADD
enter in cell d19
=SUM(D11:D17) -- Greetings from New Zealand "CHRIS" wrote in message ... I'M REAL NEW TO EXCEL..... I NEED TO ADD D11 + D12 + D13+ D14+ D15 + D16 + D17 WITH THE ANSWER IN D19 I'VE BEEN WORKING FOR ABOUT 1 HR. AND STILL IT DOES NOT ADD UP NO TOTAL IN D19......HELP....THANK YOU.... -- CHEROKEE |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
HOW DO I ADD
Chris,
Switch of the caps and put this in d19 =SUM(D11:D17) Mike "CHRIS" wrote: I'M REAL NEW TO EXCEL..... I NEED TO ADD D11 + D12 + D13+ D14+ D15 + D16 + D17 WITH THE ANSWER IN D19 I'VE BEEN WORKING FOR ABOUT 1 HR. AND STILL IT DOES NOT ADD UP NO TOTAL IN D19......HELP....THANK YOU.... -- CHEROKEE |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
HOW DO I ADD
I NEED TO ADD D11 + D12 + D13+ D14+ D15 + D16 + D17 WITH THE ANSWER IN D19 I'VE BEEN WORKING FOR ABOUT 1 HR. AND STILL IT DOES NOT ADD UP NO TOTAL IN D19......HELP....THANK YOU.... -- CHEROKEE enter this in cell d19: =SUM(D11:D17) |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
HOW DO I ADD
I USE THE CAPS BECAUSE IT'S EASY FOR ME TO SEE...
BUT I DID AS YOU TOLD ME & I STILL DON'T GET A SUM IN D19... I DID TRY TO TYPE =SUM(D11:D19) IN BOTH THE D19 CELL AND ABOVE IN THE LINE... I'M TRYING TO ADD UP A WEEKS MILAGE ON MY CAR MON-SAT WITH A TOTAL FOR THE WEEK IN CELL D19....& I WANT TO KEEP IT AS A TEMPLET... -- CHEROKEE "Mike H" wrote: Chris, Switch of the caps and put this in d19 =SUM(D11:D17) Mike "CHRIS" wrote: I'M REAL NEW TO EXCEL..... I NEED TO ADD D11 + D12 + D13+ D14+ D15 + D16 + D17 WITH THE ANSWER IN D19 I'VE BEEN WORKING FOR ABOUT 1 HR. AND STILL IT DOES NOT ADD UP NO TOTAL IN D19......HELP....THANK YOU.... -- CHEROKEE |
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
HOW DO I ADD
What result do you get in D19?
What data have you entered in cells D11, D12 etc.? George Gee "CHRIS" wrote in message ... I USE THE CAPS BECAUSE IT'S EASY FOR ME TO SEE... BUT I DID AS YOU TOLD ME & I STILL DON'T GET A SUM IN D19... I DID TRY TO TYPE =SUM(D11:D19) IN BOTH THE D19 CELL AND ABOVE IN THE LINE... I'M TRYING TO ADD UP A WEEKS MILAGE ON MY CAR MON-SAT WITH A TOTAL FOR THE WEEK IN CELL D19....& I WANT TO KEEP IT AS A TEMPLET... -- CHEROKEE "Mike H" wrote: Chris, Switch of the caps and put this in d19 =SUM(D11:D17) Mike "CHRIS" wrote: I'M REAL NEW TO EXCEL..... I NEED TO ADD D11 + D12 + D13+ D14+ D15 + D16 + D17 WITH THE ANSWER IN D19 I'VE BEEN WORKING FOR ABOUT 1 HR. AND STILL IT DOES NOT ADD UP NO TOTAL IN D19......HELP....THANK YOU.... -- CHEROKEE |
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
HOW DO I ADD
GEORGE GEE ...THANKS FOR THE REPLY....I DID NOT GET ANY RESULT IN D19....
AS FOR D11-D17 I DID NOT PUT ANYTHING IN THEM...I ONLY PUT =SUM(D11:D17) IN CELL D19....& THAT'S WHERE IT STAYED....I'M SURE THIS IS VEWRY EASY....BUT I'M MISSING SOMETHING...YOU GUYS MUST THINK I'M A JERK... BUT I CAN USE EXCEL IN OTHER WAYS... WHEN I PUT THE INFO AS I WAS TOLD IN D19 & PUSHED THE ENTER KEY NOTHING HAPPENED...ALL THE INFO STAYED IN D19 -- CHEROKEE "George Gee" wrote: What result do you get in D19? What data have you entered in cells D11, D12 etc.? George Gee "CHRIS" wrote in message ... I USE THE CAPS BECAUSE IT'S EASY FOR ME TO SEE... BUT I DID AS YOU TOLD ME & I STILL DON'T GET A SUM IN D19... I DID TRY TO TYPE =SUM(D11:D19) IN BOTH THE D19 CELL AND ABOVE IN THE LINE... I'M TRYING TO ADD UP A WEEKS MILAGE ON MY CAR MON-SAT WITH A TOTAL FOR THE WEEK IN CELL D19....& I WANT TO KEEP IT AS A TEMPLET... -- CHEROKEE "Mike H" wrote: Chris, Switch of the caps and put this in d19 =SUM(D11:D17) Mike "CHRIS" wrote: I'M REAL NEW TO EXCEL..... I NEED TO ADD D11 + D12 + D13+ D14+ D15 + D16 + D17 WITH THE ANSWER IN D19 I'VE BEEN WORKING FOR ABOUT 1 HR. AND STILL IT DOES NOT ADD UP NO TOTAL IN D19......HELP....THANK YOU.... -- CHEROKEE |
#9
Posted to microsoft.public.excel.newusers
|
|||
|
|||
HOW DO I ADD
WHEN I PUT THE INFO AS I WAS TOLD IN D19 &
PUSHED THE ENTER KEY NOTHING HAPPENED... ALL THE INFO STAYED IN D19 In other words after you typed the formula and hit the enter key this what you see in cell D19: =SUM(D11:D19) If, as you say, there is no data entered in the range D11:D19 then the formula should return a result of 0. If you don't see 0 and instead you see the formula itself try this: Select cell D19 Goto the menu FormatCellsNumber tabselect GeneralOK With cell D19 still selected press function key F2 then hit enter. -- Biff Microsoft Excel MVP "CHRIS" wrote in message ... GEORGE GEE ...THANKS FOR THE REPLY....I DID NOT GET ANY RESULT IN D19.... AS FOR D11-D17 I DID NOT PUT ANYTHING IN THEM...I ONLY PUT =SUM(D11:D17) IN CELL D19....& THAT'S WHERE IT STAYED....I'M SURE THIS IS VEWRY EASY....BUT I'M MISSING SOMETHING...YOU GUYS MUST THINK I'M A JERK... BUT I CAN USE EXCEL IN OTHER WAYS... WHEN I PUT THE INFO AS I WAS TOLD IN D19 & PUSHED THE ENTER KEY NOTHING HAPPENED...ALL THE INFO STAYED IN D19 -- CHEROKEE "George Gee" wrote: What result do you get in D19? What data have you entered in cells D11, D12 etc.? George Gee "CHRIS" wrote in message ... I USE THE CAPS BECAUSE IT'S EASY FOR ME TO SEE... BUT I DID AS YOU TOLD ME & I STILL DON'T GET A SUM IN D19... I DID TRY TO TYPE =SUM(D11:D19) IN BOTH THE D19 CELL AND ABOVE IN THE LINE... I'M TRYING TO ADD UP A WEEKS MILAGE ON MY CAR MON-SAT WITH A TOTAL FOR THE WEEK IN CELL D19....& I WANT TO KEEP IT AS A TEMPLET... -- CHEROKEE "Mike H" wrote: Chris, Switch of the caps and put this in d19 =SUM(D11:D17) Mike "CHRIS" wrote: I'M REAL NEW TO EXCEL..... I NEED TO ADD D11 + D12 + D13+ D14+ D15 + D16 + D17 WITH THE ANSWER IN D19 I'VE BEEN WORKING FOR ABOUT 1 HR. AND STILL IT DOES NOT ADD UP NO TOTAL IN D19......HELP....THANK YOU.... -- CHEROKEE |
#10
Posted to microsoft.public.excel.newusers
|
|||
|
|||
HOW DO I ADD
Chris
Type 20 in cell D11 Type 30 in cell D12 Type =SUM(D11:D17) in cell D19 Do you get a result in D19? George Gee "CHRIS" wrote in message ... GEORGE GEE ...THANKS FOR THE REPLY....I DID NOT GET ANY RESULT IN D19.... AS FOR D11-D17 I DID NOT PUT ANYTHING IN THEM...I ONLY PUT =SUM(D11:D17) IN CELL D19....& THAT'S WHERE IT STAYED....I'M SURE THIS IS VEWRY EASY....BUT I'M MISSING SOMETHING...YOU GUYS MUST THINK I'M A JERK... BUT I CAN USE EXCEL IN OTHER WAYS... WHEN I PUT THE INFO AS I WAS TOLD IN D19 & PUSHED THE ENTER KEY NOTHING HAPPENED...ALL THE INFO STAYED IN D19 -- CHEROKEE "George Gee" wrote: What result do you get in D19? What data have you entered in cells D11, D12 etc.? George Gee "CHRIS" wrote in message ... I USE THE CAPS BECAUSE IT'S EASY FOR ME TO SEE... BUT I DID AS YOU TOLD ME & I STILL DON'T GET A SUM IN D19... I DID TRY TO TYPE =SUM(D11:D19) IN BOTH THE D19 CELL AND ABOVE IN THE LINE... I'M TRYING TO ADD UP A WEEKS MILAGE ON MY CAR MON-SAT WITH A TOTAL FOR THE WEEK IN CELL D19....& I WANT TO KEEP IT AS A TEMPLET... -- CHEROKEE "Mike H" wrote: Chris, Switch of the caps and put this in d19 =SUM(D11:D17) Mike "CHRIS" wrote: I'M REAL NEW TO EXCEL..... I NEED TO ADD D11 + D12 + D13+ D14+ D15 + D16 + D17 WITH THE ANSWER IN D19 I'VE BEEN WORKING FOR ABOUT 1 HR. AND STILL IT DOES NOT ADD UP NO TOTAL IN D19......HELP....THANK YOU.... -- CHEROKEE |
#11
Posted to microsoft.public.excel.newusers
|
|||
|
|||
HOW DO I ADD
I USE THE CAPS BECAUSE IT'S EASY FOR ME TO SEE...
But it is annoying as Hell for those you are asking help from; besides, why do you have to see it... you already know what it says.<g Seriously, it is very hard to read around all those upper case letters (some consider it the equivalent of shouting) and it is considered rude to use it. It would be most welcomed if you would refrain from using all caps in your future postings. -- Rick (MVP - Excel) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|