In my cells for example:
Cell
A1 A2 A3 A4 A5 A6....etc
B 5 D 7 B 3
In the example above cells A1 & A2 go together such as if the value in A1 = B then I need the value in A2 which is 5. I need the value of the cells where the previous cell/cells = B
In the example above, A1 and A5 = B.......so I need the values summed in A2 and A6, which would be 5+3=8
Not sure if that makes sense, but what im looking for.
Cell
A1 A2 A3 A4 A5 A6....etc
B 5 D 7 B 3
In the example above cells A1 & A2 go together such as if the value in A1 = B then I need the value in A2 which is 5. I need the value of the cells where the previous cell/cells = B
In the example above, A1 and A5 = B.......so I need the values summed in A2 and A6, which would be 5+3=8
Not sure if that makes sense, but what im looking for.