Log inRegister
You are here: Boossy » TableCalc
COLUMN 1 COLUMN 2 COLUMN 3
ARİF A
ABC
240
ART B
ABC
240
ARTE MÜH
ABC
20
BİRK KOÇ
XYZ
10
BSAN YA
XYZ
20
 
TOTAL
530
 
∑ABC
500
 
∑XYZ
30
The number of "ABC"
3
ELSE
 
 
$IF(0
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.
This site is powered by FoswikiCopyright © by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding Foswiki? Send feedback
This page was cached on 09 Feb 2023 - 06:23.