Percentage of dates that are 7 days late
 

I'm trying to create a formula that will give me the Percent of Activities
with Actual Comp. Dtd. (column C) More than 7 Days after Recommended Comp.
Dtd. (column B). In the example there may be dates in column B and none in
column C these are to ignored. I have thousands of rows so I don't want to
add a formuls in another column that determines each one separatly and than
sum them up. I need to do it in one step.

A B C
Act 1 2/3/09 2/5/09
Act 2 6/7/09 7/6/09
Act 3 1/5/09 3/4/09
Act 4 4/3/09
8/9/09

Robert K

Percentage of dates that are 7 days late
 

Maybe this:

=SUMPRODUCT(--(C2:C100-B2:B1007))/COUNT(C2:C100)

Format as Percentage

--
Biff
Microsoft Excel MVP


"RobertK" wrote in message
...
I'm trying to create a formula that will give me the Percent of Activities
with Actual Comp. Dtd. (column C) More than 7 Days after Recommended Comp.
Dtd. (column B). In the example there may be dates in column B and none
in
column C these are to ignored. I have thousands of rows so I don't want
to
add a formuls in another column that determines each one separatly and
than
sum them up. I need to do it in one step.

A B C
Act 1 2/3/09 2/5/09
Act 2 6/7/09 7/6/09
Act 3 1/5/09 3/4/09
Act 4 4/3/09
8/9/09

Robert K

Percentage of dates that are 7 days late
 

Thanks, I may have another one for you but I like to exhaust all my
possibilites first.
--
Robert K


"RobertK" wrote:

I'm trying to create a formula that will give me the Percent of Activities
with Actual Comp. Dtd. (column C) More than 7 Days after Recommended Comp.
Dtd. (column B). In the example there may be dates in column B and none in
column C these are to ignored. I have thousands of rows so I don't want to
add a formuls in another column that determines each one separatly and than
sum them up. I need to do it in one step.

A B C
Act 1 2/3/09 2/5/09
Act 2 6/7/09 7/6/09
Act 3 1/5/09 3/4/09
Act 4 4/3/09
8/9/09

Robert K

Percentage of dates that are 7 days late
 

We're always open!

Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"RobertK" wrote in message
...
Thanks, I may have another one for you but I like to exhaust all my
possibilites first.
--
Robert K


"RobertK" wrote:

I'm trying to create a formula that will give me the Percent of
Activities
with Actual Comp. Dtd. (column C) More than 7 Days after Recommended
Comp.
Dtd. (column B). In the example there may be dates in column B and none
in
column C these are to ignored. I have thousands of rows so I don't want
to
add a formuls in another column that determines each one separatly and
than
sum them up. I need to do it in one step.

A B C
Act 1 2/3/09 2/5/09
Act 2 6/7/09 7/6/09
Act 3 1/5/09 3/4/09
Act 4 4/3/09
8/9/09

Robert K