Thank you
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!! |
Thank you
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!! |
All times are GMT +1. The time now is 12:20 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com