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
|