Did NOT test. Try this arrary formula which must be entered using
ctrl+shift+enter
=average(if(A2:A213=C224,A2:A213<=C225,W2:W213=1, H2:H213))

--
Don Guillett
SalesAid Software

"jrheinschm" wrote in message
...
=SUMPRODUCT(--(A2:A213=C224),--(A2:A213<=C225),--(W2:W213=1),H2:H213)/SUMPRODUCT(--(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