Foswiki Spreadsheet Plugin

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.

-- OsgbUtopya - 30 Nov 2022

Commenting is disabled while not logged in