Using an If statement to recognize a null cell and complete a separate formula

[swim1686]

Hi! I will try to keep this as easy as possible. Thanks for any help in advance!

I am attempting to figure out the run rate for the number of contracts sent by individual person. I have the formula for run rate =(Total Number of Contracts Sent/Number of Days that have occured in the month)*total business days in the month.

F5 = Total Number of Contract sent
5=Number of days that have occured
23 = Number of business days in October

Formula=(F5/5)*23

What I am trying to figure out is an automatic way to update the number of days that have occurred in the month.

Cell F5 is the sum of cells L5:AP5 = the total number of contracts sent. Cells L5:AP5 list stand for each day of the month. I have populated cells L2:AP2 with the business days of the month. 1-23.

Is there a formula that would reference cells L2:AP2 to automatically update the formula =(F5/5)*23?

Thanks!

 

[Gerald Higgins]

What does L5:AP5 actually contain ?

For example, if L5 refers to Monday 1st October, what value is actually in L5 ?
And what's in M5 for Tuesday 2nd, and so on.

 

[swim1686]

Hi Gerald,

L5:AP5 would be the number of contracts sent. The numbers 0-10. If they day hasn't occurred yet, the cell will remain blank.

What does L5:AP5 actually contain ?

For example, if L5 refers to Monday 1st October, what value is actually in L5 ?
And what's in M5 for Tuesday 2nd, and so on.