Hello,
Can you please help me with this?
Example:
Can you please help me with this?
- There are random numerical values in the cells of column A:
- Cells in column B can contain one of two specific text string values "ABC" or "XYZ", that are randomly sorted as well.
- For any cell in column B where the text is equal to "ABC" sum the corresponding cells in column A
- Same goes for any cell in column B where the text is equal to "XYC"
Example:
A1 = 623 ... B1 = XYZ
A2 = 305 ... B2 = ABC
A3 = 274 ... B3 = ABC
A4 = 839 ... B4 = XYZ
B1 and B4 = XYZ C1 = A1+A4
B2 and B3 = ABC C2 = A2+A3
Thanks!