Formula for B to continue adding C Daily

C

Crystal

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
 
R

Rik Smith

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
 
C

Crystal

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.
 
C

Crystal

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

Tom Ogilvy

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