Formula for B to continue adding C Daily
 

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

Formula for B to continue adding C Daily
 

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
"Crystal" wrote:

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

Formula for B to continue adding C Daily
 

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

--
Regards,
Tom Ogilvy

"Crystal" wrote in message
...
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

Formula for B to continue adding C Daily
 

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.

"Tom Ogilvy" wrote:

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

--
Regards,
Tom Ogilvy

"Crystal" wrote in message
...
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

Formula for B to continue adding C Daily
 

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

Regards.
Jorge
"Crystal" escreveu na mensagem
...
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.

"Tom Ogilvy" wrote:

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

--
Regards,
Tom Ogilvy

"Crystal" wrote in message
...
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

Formula for B to continue adding C Daily
 

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

"Jorge Rodrigues" wrote:

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

Regards.
Jorge
"Crystal" escreveu na mensagem
...
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.

"Tom Ogilvy" wrote:

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

--
Regards,
Tom Ogilvy

"Crystal" wrote in message
...
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

Formula for B to continue adding C Daily
 

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

--
Regards,
Tom Ogilvy

"Crystal" wrote in message
...
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.

"Tom Ogilvy" wrote:

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

--
Regards,
Tom Ogilvy

"Crystal" wrote in message
...
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

Formula for B to continue adding C Daily
 

Please check your e-mail.
Regards.
Jorge

"Crystal" escreveu na mensagem
...
Sory Jorge I did after I sent this last one...Sorry for being a Pain in
the
Buttucks

"Jorge Rodrigues" wrote:

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

Regards.
Jorge
"Crystal" escreveu na mensagem
...
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.

"Tom Ogilvy" wrote:

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

--
Regards,
Tom Ogilvy

"Crystal" wrote in message
...
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