A
Adam
need some help on this,
ie budget spreadsheet
row is the variable, ie production tons
columns are months, Plan and actual, ie b3 is january Plan, c3 is january
actual
d3 is february plan and e3 is february actual, and so on for the remaining
months
\at the end of row 3, there is a "YTD plan" cell, say z3.
what formula would work so that it will sum up only the planned #'s for
months that have entered "actual" for those months
hence giving me the YTD plan to compare with my entered actuals
ie if I planned 10 for every month, it is now june, so I would have actual
numbers from jan to May. The YTD cell would only sum up the "planned" cells
for which actuals were entered. meaning the cell would sum up to equal 50
(the 5 months with actuals)
ie budget spreadsheet
row is the variable, ie production tons
columns are months, Plan and actual, ie b3 is january Plan, c3 is january
actual
d3 is february plan and e3 is february actual, and so on for the remaining
months
\at the end of row 3, there is a "YTD plan" cell, say z3.
what formula would work so that it will sum up only the planned #'s for
months that have entered "actual" for those months
hence giving me the YTD plan to compare with my entered actuals
ie if I planned 10 for every month, it is now june, so I would have actual
numbers from jan to May. The YTD cell would only sum up the "planned" cells
for which actuals were entered. meaning the cell would sum up to equal 50
(the 5 months with actuals)