Had a question about sumproduct and looking at prior posts and came up with
the following formula.

=SUMPRODUCT($F$5:$F$370,--(MOD($B$5:$B$370,7)=$S7))/SUMPRODUCT(--($F$5:$F$3700),--(MOD($B$5:$B$370,7)=$S7))

There is a wealth of knowledge in prior posts.

I really appreciate having this forum available and the help that it has
provided over the years.

Macro's are still a little foreign - mainly because I don't know all the
keywords.

Thanks again!!