COLUMN 1	COLUMN 2	COLUMN 3
	TOTAL	530
	∑ABC	500
	∑XYZ	30
		$IF(0
ARİF A	ABC	240
ART B	ABC	240
ARTE MÜH	ABC	20
BİRK KOÇ	XYZ	10
BSAN YA	XYZ	20
The number of "ABC"	3	ELSE
The number of "XYZ"	2	240

I need a formulation for below table:

COLUMN 1	COLUMN 2	COLUMN 3
ARİF A	ABC	240	edit
ART B	ABC	240	edit
ARTE MÜH	ABC	20	edit
BİRK KOÇ	XYZ	10	edit
BSAN YA	XYZ	20	edit
	TOTAL	530	edit
	∑ABC	500	edit
	∑XYZ	30	edit
The number of "ABC"	3		edit
The number of "XYZ"	2		edit

As it can be seen in above table ∑ABC=500 for COLUMN 3 when we take into consideration "ABC" values in COLUMN 2. How can I get the sum value of "ABC" (500) from "COLUMN 3" by using Spreadsheet Plugin. Thanks in advance for your support.