Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Addition Formula
I am trying to add a number in one cell to another cell which contains a YTD
total. How to i create this YTD total w/o creating another blank cell Example Cell 1 = number changes weekly Cell 2 = number here should add Cell 1 for a YTD total |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Addition Formula
Couldnt understand it!
Can you explain it through example. "LyndaP" wrote: I am trying to add a number in one cell to another cell which contains a YTD total. How to i create this YTD total w/o creating another blank cell Example Cell 1 = number changes weekly Cell 2 = number here should add Cell 1 for a YTD total |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Addition Formula
Example Current Week
Incidences Goal 80 Weeky Total 1 YTD 16 Example Next Week Incidences Goal 80 Weekly Total 2 YTD 18 When I change the Weekly # I want the YTD cell calculate YTD Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Addition Formula
I am trying to add a number in one cell to another cell which contains
a YTD total. How to i create this YTD total w/o creating another blank cell Example Cell 1 = number changes weekly Cell 2 = number here should add Cell 1 for a YTD total Here's one way using Excel 2003. In Sheet1, the weekly entry is in B2 and the YTD total will be in C2. First, in Tools Options Calculation check the "Iteration" box to allow circular references. The approach uses Sheet2 as a workspace. In Sheet2 make these entries: In A2: =IF(OR(A1="",A1=TODAY()),"",IF(A2="",TODAY(),A2)) In B2: =IF(A2=TODAY(),Sheet1!$B$2,B2) Then copy A2:B2 down for 52 rows (a year of weeks). Format column A as dates. Then in A1 put today's date. Finally, in Sheet1!B3 put =SUM(Sheet2!B:B) Here's how it works. Sheet2 keeps a running list of entries. This is useful in locating data-entry errors after the fact. Sheet2 captures at most one number from Sheet1!$B$2 per day: the last entered that day. It starts tomorrow. (You could use WEEKNUM(...) in the test instead of just TODAY() if you want to be stricter about when the data is entered). |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Retraction (was: Addition Formula)
I take this back ... got to think about it some more.
Sorry about the false start. I am trying to add a number in one cell to another cell which contains a YTD total. How to i create this YTD total w/o creating another blank cell Example Cell 1 = number changes weekly Cell 2 = number here should add Cell 1 for a YTD total Here's one way using Excel 2003. In Sheet1, the weekly entry is in B2 and the YTD total will be in C2. First, in Tools Options Calculation check the "Iteration" box to allow circular references. The approach uses Sheet2 as a workspace. In Sheet2 make these entries: In A2: =IF(OR(A1="",A1=TODAY()),"",IF(A2="",TODAY(),A2)) In B2: =IF(A2=TODAY(),Sheet1!$B$2,B2) Then copy A2:B2 down for 52 rows (a year of weeks). Format column A as dates. Then in A1 put today's date. Finally, in Sheet1!B3 put =SUM(Sheet2!B:B) Here's how it works. Sheet2 keeps a running list of entries. This is useful in locating data-entry errors after the fact. Sheet2 captures at most one number from Sheet1!$B$2 per day: the last entered that day. It starts tomorrow. (You could use WEEKNUM(...) in the test instead of just TODAY() if you want to be stricter about when the data is entered). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for addition | Excel Worksheet Functions | |||
Addition & multiplication formula | Excel Discussion (Misc queries) | |||
Addition help to edit a formula | Excel Worksheet Functions | |||
Formula Addition Copy | Excel Discussion (Misc queries) | |||
help with simple addition formula | Excel Worksheet Functions |