Hi,
I'd like to be able to sum every n rows in a single array so the values are kept and can be multiplied separately?
Currently the only way I can see to sum every n rows uses 2 arrays which is shown below so the separate values are lost
=SUMPRODUCT(B1:B15,MOD(ROW(B1:B15)+0,2))
No, there is not a way to store the individual values within a "result" formula for reuse. But there is no need. Your formula above is already referencing every ODD row and summing them as a group. So this formula already knows how to find the values. You can do multiplication on the initial range of values and get your new result using the same basic formula.
=SUMPRODUCT(B1:B15,MOD(ROW(B1:B15)+0,2))
=SUMPRODUCT((B1:B15)*2,MOD(ROW(B1:B15)+0,2))
=SUMPRODUCT((B1:B15)*M3,MOD(ROW(B1:B15)+0,2))
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks