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!!

You're welcome Brad, from all of us.......yours is a good example of the
value of each OP posting a good subject that can be easily researched later,
and for giving good closure to the post once the solution is achieved.

Vaya con Dios,
Chuck, CABGx3



"Brad" wrote:

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!!