Using current date track budget.

[Daire]

Hi,

I am trying to update a percentage completion cell in a budget
tracking spreadsheet based on the current month. Basically I have a
row for each activity and a column for each month. I enter the hours
completed for each activity in each month. I have a total number of
hours value which will be used to calculate the %completed.

So what I need is to a formula that will calculate the following:

if ( this month is April) then (sum the hours from start month to
april and divide by the total hours cell)
else if (this month is May) then (sum the hours from start month to
april and divide by the total hours cell)
else etc. etc.

Any help on this would be great.

Thanks,#
Daire

 

[Roger Govier]

Hi Daire

Supposing your hours are in cells B3:M3, with Jan hours in B3, Feb in C3
etc. and your total hours are in N3
=SUM($B$3:INDEX(B3:M3,MONTH(TODAY())))/N3
Format the cell with the formula as Percentage
--
Regards
Roger Govier

Hi,

I am trying to update a percentage completion cell in a budget
tracking spreadsheet based on the current month. Basically I have a
row for each activity and a column for each month. I enter the hours
completed for each activity in each month. I have a total number of
hours value which will be used to calculate the %completed.

So what I need is to a formula that will calculate the following:

if ( this month is April) then (sum the hours from start month to
april and divide by the total hours cell)
else if (this month is May) then (sum the hours from start month to
april and divide by the total hours cell)
else etc. etc.

Any help on this would be great.

Thanks,#
Daire

__________ Information from ESET Smart Security, version of virus
signature database 4767 (20100113) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4767 (20100113) __________

The message was checked by ESET Smart Security.

http://www.eset.com