How to sum cells values conditional to the content of other cell?

[3d1l]

Hello,

Can you please help me with this?

1. There are random numerical values in the cells of column A:
2. Cells in column B can contain one of two specific text string values "ABC" or "XYZ", that are randomly sorted as well.
3. For any cell in column B where the text is equal to "ABC" sum the corresponding cells in column A
4. 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!

 

[Eric W]

Welcome to the MrExcel forum!

Try:

Book4
	A	B	C
1	623	XYZ	1462
2	305	ABC	579
3	274	ABC
4	839	XYZ
Sheet12

Cell Formulas
Range	Formula
C1	C1	=SUMIFS(A:A,B:B,"XYZ")
C2	C2	=SUMIFS(A:A,B:B,"ABC")

 

[3d1l]

Eric, there is no doubt about it... you are definitively a MrExcel MVP.

Is working!!!

Thanks.

 

[Eric W]

Happy to help! Thanks for the update. ?