Formula for B to continue adding C Daily

[Guest]

Hello again... what I am looking for is the Formula that when you add a
Number to (B) on a daily basis that (C) would keep a running YTD total. Can
someone Please help me?
(A) (B) (C)
TODAY 2004
PHONE CALLS 24,329
CELL CALLS 9,610
911 CALLS 2,607
877 CALLS 506
DUI CALLS 590
PEOPLE/POST 1,200
CAR CBA 174
POST CBA 10
MVI CHECKS 117
FOOT PATROLS 397
SCHOOL BUS FOLLOWED 30
SCHOOL BUS HP-7'S 0
SCHOOL ZONES WORKED 3
SCHOOL ZONE HP-7'S 0

 

[Guest]

Hi Crystal,

If you don't have other columns with previous days' numbers, I don't think
you can get what you're looking for. If you rearrange your data, you might
be able to.

phone calls cell calls 911 calls
jan 1 5 3 10
jan 2 6 7 2
....
today 2 4 8

YTD 13 14 20

The YTD formulae is =sum($B$2:$B$10).

Hope to help.
Rik

 

[Tom Ogilvy]

This really isn't supported. See original thread for a suggestion.

 

[Guest]

Mr. Ogilvy do you think you can help me? This is considered a Daily Follow up
that gets attached to another document...doing it the way Mr. Smith is
suggesting would take up too much room. Can someone PLEASE help. There has to
be a way.

 

[Jorge Rodrigues]

Why don't you see the answers to your initial post?

Regards.
Jorge

 

[Guest]

Sory Jorge I did after I sent this last one...Sorry for being a Pain in the
Buttucks

 

[Tom Ogilvy]

Are you storing the YTD totals up through the previous day in some other
location? Perhaps some other sheet?

 

[Jorge Rodrigues]

Please check your e-mail.
Regards.
Jorge

Sory Jorge I did after I sent this last one...Sorry for being a Pain in the
Buttucks