D
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
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