If Function

  • Thread starter Thread starter MSwabb
  • Start date Start date
M

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.
 
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.
 
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.
 
Back
Top