I would like a formula that will do the following:
There are 3 codes for Column D: V, Q, or S.
Example: If D2=V, then the value in H2 would be added into cell H40. Then if D3=V too, then the value of H3 would be added into cell H40. If D4=V, then the value of H4 would be added into cell H41. Cell H42 would be used for values that had a code of S.
The outcome is meant to be that there will be 3 cells with values in that are made up of whether the data has a code of V, Q, or S.
Sorry if this is confusing, it’s harder to write what I want than it is to think about it in my head.
Cheers