Thread: HOW DO I ADD
View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.newusers
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default 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