This is my first post, and only as a final resort.

Im sure someone must know the answer to this, but...

Code:

`=SUMPRODUCT(--('Sheet1'!$K$2:$K$3223>=$B5),--('Sheet1'!$K$2:$K$3223<$B6),--('Sheet1'!$CM$2:$CM$3223=C$4))/384`

Code:

`=SUMPRODUCT(--('Sheet1'!$K$2:$K$3223>=$B5),--('Sheet1'!$K$2:$K$3223<$B6),--('Sheet1'!$CM$2:$CM$3223=C$4))/J5`

thanks