LinkBack URL
About LinkBacks
I don't think you need to enter this as an array formula as the Sumproduct is doing that part for you.
It also might be a good idea to stay away from offset as it's volatile.
=SUMPRODUCT(SUMIF(A:A,D2:INDEX(D:D,MATCH(REPT("z",255),D:D)),B:B))
I don't think you need to enter this as an array formula as the Sumproduct is doing that part for you.
It also might be a good idea to stay away from offset as it's volatile.
=SUMPRODUCT(SUMIF(A:A,D2:INDEX(D:D,MATCH(REPT("z",255),D:D)),B:B))
Last edited by jeffreybrown; 11-19-2018 at 11:50 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks