Log inRegister
You are here: Boossy » TableCalc
COLUMN 1 COLUMN 2 COLUMN 3Sorted ascending
BİRK KOÇ
XYZ
10
ARTE MÜH
ABC
20
BSAN YA
XYZ
20
 
∑XYZ
30
ARİF A
ABC
240
ART B
ABC
240
The number of "XYZ"
2
240
 
∑ABC
500
 
TOTAL
530
 
 
$IF(0
The number of "ABC"
3
ELSE
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 19 Mar 2024 - 13:46.