| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding Daily | Excel Worksheet Functions | |||
| Automatic Adding Daily | Excel Worksheet Functions | |||
| Adding daily updates without re-doing everything | Excel Discussion (Misc queries) | |||
| continue adding inventory | Excel Worksheet Functions | |||
| Adding a check mark to the custom made toolbar/menu continue...... | Excel Programming | |||
Linear Mode
