| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
YTD budget based on current input of actual
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec YTD
actual 10 20 30 40 30 130 budget 15 15 20 25 20 25 35 20 25 30 35 15 ....... Need a formula in YTD budget row so that when I enter 10 in Jun actual (140 YTD actual) so that I can get 120 in YTD budget. Thanks for the help. Sanj |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
YTD budget based on current input of actual
Labels (Jan , Feb ..) in B1:M12
Actual values in B2:M2 Budget values in B3:M3 =SUM(B3:M3)-SUMIF(B2:M2,"",B3:M3) best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Sanj" wrote in message ... Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec YTD actual 10 20 30 40 30 130 budget 15 15 20 25 20 25 35 20 25 30 35 15 ....... Need a formula in YTD budget row so that when I enter 10 in Jun actual (140 YTD actual) so that I can get 120 in YTD budget. Thanks for the help. Sanj |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
YTD budget based on current input of actual
Thanks Bernard. It works pefectly!!!
"Bernard Liengme" wrote: Labels (Jan , Feb ..) in B1:M12 Actual values in B2:M2 Budget values in B3:M3 =SUM(B3:M3)-SUMIF(B2:M2,"",B3:M3) best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Sanj" wrote in message ... Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec YTD actual 10 20 30 40 30 130 budget 15 15 20 25 20 25 35 20 25 30 35 15 ....... Need a formula in YTD budget row so that when I enter 10 in Jun actual (140 YTD actual) so that I can get 120 in YTD budget. Thanks for the help. Sanj |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
YTD budget based on current input of actual
You are most welcome
-- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Sanj" wrote in message ... Thanks Bernard. It works pefectly!!! "Bernard Liengme" wrote: Labels (Jan , Feb ..) in B1:M12 Actual values in B2:M2 Budget values in B3:M3 =SUM(B3:M3)-SUMIF(B2:M2,"",B3:M3) best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Sanj" wrote in message ... Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec YTD actual 10 20 30 40 30 130 budget 15 15 20 25 20 25 35 20 25 30 35 15 ....... Need a formula in YTD budget row so that when I enter 10 in Jun actual (140 YTD actual) so that I can get 120 in YTD budget. Thanks for the help. Sanj |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
YTD budget based on current input of actual
[My response to your duplicate posting in m.p.e.worksheet.functions. In the
future, it is better to post in only one m.p.excel NG.] "Sanj" wrote: Need a formula in YTD budget row so that when I enter 10 in Jun actual (140 YTD actual) so that I can get 120 in YTD budget. One way: For actual YTD: =SUM(B1:M1) For budget YTD: =SUMPRODUCT(--(B1:M1<""),B2:M2) ----- original message ----- "Sanj" wrote in message ... Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec YTD actual 10 20 30 40 30 130 budget 15 15 20 25 20 25 35 20 25 30 35 15 ....... Need a formula in YTD budget row so that when I enter 10 in Jun actual (140 YTD actual) so that I can get 120 in YTD budget. Thanks for the help. Sanj |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
YTD budget based on current input of actual
Thanks for your help. Will definitely do in future.
"JoeU2004" wrote: [My response to your duplicate posting in m.p.e.worksheet.functions. In the future, it is better to post in only one m.p.excel NG.] "Sanj" wrote: Need a formula in YTD budget row so that when I enter 10 in Jun actual (140 YTD actual) so that I can get 120 in YTD budget. One way: For actual YTD: =SUM(B1:M1) For budget YTD: =SUMPRODUCT(--(B1:M1<""),B2:M2) ----- original message ----- "Sanj" wrote in message ... Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec YTD actual 10 20 30 40 30 130 budget 15 15 20 25 20 25 35 20 25 30 35 15 ....... Need a formula in YTD budget row so that when I enter 10 in Jun actual (140 YTD actual) so that I can get 120 in YTD budget. Thanks for the help. Sanj |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Percentage Difference Between Budget & Actual | Excel Discussion (Misc queries) | |||
| Compare budget to actual | Excel Discussion (Misc queries) | |||
| Budget vs. Actual | Excel Discussion (Misc queries) | |||
| Comparing actual spends against a budget | Charts and Charting in Excel | |||
| YTD Budget Sum if Actual Month has activities | Excel Worksheet Functions | |||
Linear Mode
