If Function

[MSwabb]

I am looking for someone that can help me define a
function/formula to calculate the the following.

If I have 12 entries (Jan-Dec)in 12 consecutive columns
and a total column (monthly YTD)where I need to see the
sum of the columns to the date

EX: Sum of column 1-5 will represent Jan-May. Then in June
it will need to be sum 1-6.

I need to see the cumulative total as the months progress
(Month 1 then Month 1+ Month 2, and so on) without adding
the future numbers.

Ex: At Current Month YTD Monthly Plan we need to see the
sum plan number up to the current month but for
forecasting purposes we need to see the numbers as I have
already entered them (by individual month) without being
added to the prior month.

If there is a formula with an "IF" condition that the
numbers can be added up to the current month but without
changing the future until due.

 

[Andy B]

Hi

If you have a row containing monthly totals, you could use the row below for
cumulative totals. Your formulas for these cells would be something like:
=IF(B10<>0,SUM($B10:B10),"")
in B11 (with your totals in row 10). This can then be filled across and when
any monthly info is entered, the cumulative will appear below the total.

 

[RagDyeR]

With labels in A1:L1,
in the form - Jan - Feb - Mar ... etc.,

And values in A2:L2,
Try this:

=SUM(A2:INDEX(A2:L2,MATCH(TEXT(TODAY(),"mmm"),A1:L1,0)))
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I am looking for someone that can help me define a
function/formula to calculate the the following.

If I have 12 entries (Jan-Dec)in 12 consecutive columns
and a total column (monthly YTD)where I need to see the
sum of the columns to the date

EX: Sum of column 1-5 will represent Jan-May. Then in June
it will need to be sum 1-6.

I need to see the cumulative total as the months progress
(Month 1 then Month 1+ Month 2, and so on) without adding
the future numbers.

Ex: At Current Month YTD Monthly Plan we need to see the
sum plan number up to the current month but for
forecasting purposes we need to see the numbers as I have
already entered them (by individual month) without being
added to the prior month.

If there is a formula with an "IF" condition that the
numbers can be added up to the current month but without
changing the future until due.