That is because both parts of the formula are the same, so it will always
come to 1, or it would if the ranges were the same size. You have a W2:W215
which should be W2:W213

=SUMPRODUCT(--(A2:A213=C224),--(A2:A213<=C225),--(W2:W213=1),H2:H213)/SUMPR
ODUCT(--(A2:A213=C224),--(A2:A213<=C225),--(W2:W213=1))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"jrheinschm" wrote in message
...

=SUMPRODUCT(--(A2:A213=C224),--(A2:A213<=C225),--(W2:W213=1),H2:H213)/SUMPR
ODUCT(--(A2:A213=C224),--(A2:A213<=C225),--(W2:W215=1),H2:H213)
This is the suggestion one of you gave me, however it doesn't seem to
work.
col A are dates

I've been working on this for hours and can't get it??
Please help