Hi!
How do I make this work? I have the formula =sumproduct(A1:A5 ; B1:B5) but when I drag it down
it becomes =sumproduct(A2:A6 ; B2:B6), =sumproduct(A3:A7 ; B3:B7), =sumproduct(A4:A8 ; B4:B8) etc.
I want it to look like =sumproduct(A6:A10 ; B6:B10), =sumproduct(A11:A15 ; B11:B15), =sumproduct(A16:A20 ; B16:B20) etc.
Thanks a lot.
Hi,
One way:
=SUMPRODUCT(INDEX(A:A,5*(ROWS($1:1)-1)+1):INDEX(A:A,5*(ROWS($1:1)-1)+5),INDEX(B:B,5*(ROWS($1:1)-1)+1):INDEX(B:B,5*(ROWS($1:1)-1)+5))
Regards
Thank you very much, it worked out perfect
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks