Hey Panel!
Basically here is an example of my simplified problem: I have a row A that has a Special IDs, What I want to do it complete a sum product for each special ID. So D1 = B1*C1, D2 = B1*C2+B2*C2... Then D4 = B4*C4, D5 = B4*C5+B5*C4...Then D7 = B7*C7, D5 = B7*C8+B8*C7
Visually is kinda looks like:
A B C D
1 1 2 2 B1*C1 == SUMPRODUCT(B$1:B1,C$1:C1)
2 1 3 2 B1*C2+B2*C2 == SUMPRODUCT(B$1:B2,C$1:C2)
3 1 4 3 .... == SUMPRODUCT(B$1:B3,C$1:C3)
4 2 1 1 .... == SUMPRODUCT(B$4:B4,C$4:C4)
5 2 3 2 .... == SUMPRODUCT(B$4:B5,C$4:C5)
6 2 2 3 .... == SUMPRODUCT(B$4:B6,C$4:C6)
7 3 2 2 .... == SUMPRODUCT(B$7:B7,C$7:C7)
8 3 3 1 .... == SUMPRODUCT(B$7:B8,C$7:C8)
Is there a way to Automate the sumproject to only total products going down for certain IDs? I have 800+ Special ID so doing this manually is very labor intensive, any thoughts?
Thank you!!
Basically here is an example of my simplified problem: I have a row A that has a Special IDs, What I want to do it complete a sum product for each special ID. So D1 = B1*C1, D2 = B1*C2+B2*C2... Then D4 = B4*C4, D5 = B4*C5+B5*C4...Then D7 = B7*C7, D5 = B7*C8+B8*C7
Visually is kinda looks like:
A B C D
1 1 2 2 B1*C1 == SUMPRODUCT(B$1:B1,C$1:C1)
2 1 3 2 B1*C2+B2*C2 == SUMPRODUCT(B$1:B2,C$1:C2)
3 1 4 3 .... == SUMPRODUCT(B$1:B3,C$1:C3)
4 2 1 1 .... == SUMPRODUCT(B$4:B4,C$4:C4)
5 2 3 2 .... == SUMPRODUCT(B$4:B5,C$4:C5)
6 2 2 3 .... == SUMPRODUCT(B$4:B6,C$4:C6)
7 3 2 2 .... == SUMPRODUCT(B$7:B7,C$7:C7)
8 3 3 1 .... == SUMPRODUCT(B$7:B8,C$7:C8)
Is there a way to Automate the sumproject to only total products going down for certain IDs? I have 800+ Special ID so doing this manually is very labor intensive, any thoughts?
Thank you!!