SumProduct 2

[kkondrat1]

Here is my data:

End date............Sus Date............ID#

05-Feb-03..........
07-Feb-03.........28-Feb-03..........8
15-Mar-03.........
28-Mar-03.........
23-Apr-03........
30-May-03.........
24-Jun-03........
27-Jun-03..........
08-Aug-03..........
15-Aug-03.........03-Oct-03..........6
22-Aug-03........
29-Aug-03.......
19-Sep-03.......
30-Sep-03........
30-Sep-03.......
02-Oct-03.......
31-Oct-03.......
07-Nov-03.........02-Dec-03
12-Dec-03.......04-Dec-03
19-Dec-03.......
19-Dec-03........

All of the data above have ID #'s (I left it out), but only some ID#'
have a SUS Date, all ID #'s have an END Date.

What I want to do is have a column that gives me a % like below:

Feb'03........50%
Mar '03.......0%
Apr '03.......0%
May '03.......0%
Jun '03........0%
Jul '03........0%
Aug '03.......0%
Sep '03.......0%
Oct.............50%
Nov............0%
Dec............66%


I have a sumproduct formula that gives me the count, but I am havin
trouble getting the %

here is what I have so far-

=SUMPRODUCT((MCQ!$F$3:$F$22>=H6)*(MCQ!$F$3:$F$22<=DATE(YEAR(H6),MONTH(H6)+1,0))

 

[Frank Kabel]

Hi
try
=SUMPRODUCT((MCQ!$F$3:$F$22>=H6)*(MCQ!$F$3:$F$22<=DATE(YEAR(H6),MONTH(H
6)+1,0)))/SUMPRODUCT(--(MCQ!$F$3:$F$22>=H6))
and format as percentage

 

[kkondrat1]

Date1.......................Date2

28-Mar-03................01-Apr-03
15-Jul-03..................22-Jul-03
18-Jul-03..................
20-Aug-03................09-Sep-03
04-Sep-03................
23-Oct-03 ................
14-Nov-03............... 24-Nov-03
06-Oct-03 ...............
14-Oct-03 ...............
15-Oct-03 ................24-Oct-03
04-Dec-03............... 11-Dec-03
05-Nov-03...............
03-Nov-03...............
22-Sep-03...............


I have dates in the left column and dates in the right column a
displayed above:

I need to create a third column that summarizes the data as a %

so for example July appears once in the right column, 1/14=7%

so what I need to do is count up the column on the left and divide b
how many times a july date appears on the right, august
sept....................