K
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))
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))