Hi, i use sumifs formula my excel table but dont work in appsheet application
like this picture ;
Solved! Go to Solution.
Hello,
You can perform a SUMIF directly in AppSheet by using a SELECT() statement to conditionally select rows, and then summing across those.
From your screenshots, it looks like you are trying to sum everything in column D from the Arel Besin Takip table when the condition of the column B value matches the Tarihi Giriniz value in the Toplam table. If this is correct, your formula will follow this structure to achieve a sumif:
SUM(
SELECT(
Arel Besin Takip[Column D Name],
[Column B Name]=[_THISROW].[Tarihi Giriniz]
)
)
Note you will need to check the spelling and input the proper column names.
other picture
other picture ;
i write sumifs formula, This system sum โMiktarโ column, according to the โTarihโ column and " Besin รeลiti" column.
@brktfkc
May I ask why do you need to use spreadsheet formula? Why donโt you SUM the values with AppFormula inside the app?
hocam ingilizce bende a little tรผrkรงe dรถnebilrinisiz , รงรผnkรผ appformula nasฤฑl kullanฤฑlฤฑyor bilmiyorum, excelde tabloyu hazฤฑrladฤฑm formulรผ yazdฤฑm sonra yรถnlendirdim appsheete
@brktfkc
Burak Bey,
Excelโde SUMIF yapmanฤฑza gerek yok. Verileri AppSheetโdeki tablonuzda yaratacaฤฤฑnฤฑz bir Sanal Sรผtun (Virtual Column) ile de yapabilirsiniz. Yukarda zaten @Jonathon size cevap yazmฤฑล. ลayet anlayamadฤฑฤฤฑnฤฑz bir ลey olursa tekrar yazarsฤฑnฤฑz, yardฤฑmcฤฑ olmaya รงalฤฑลฤฑrฤฑm.
@Jonathon sanฤฑrฤฑm sanal sรผtun olmadan nasฤฑl yapฤฑldฤฑฤฤฑnฤฑ yazmฤฑล dimi ? bu arada bu yazฤฑlanlarฤฑ app formula kฤฑsmฤฑna yazฤฑcam spreadsheettekini silicemmi kalsada olurmu ?
@brktfkc
Spreadsheetโdeki formรผlรผ silmeniz lazฤฑm. Sadece AppFormula รถzelliฤini kullanmalฤฑsฤฑnฤฑz. Ayrฤฑca varsa Excelโdeki formรผllerinizi de kaldฤฑrmalฤฑsฤฑnฤฑz, sadece data olarak kalmalฤฑ.
Hello,
You can perform a SUMIF directly in AppSheet by using a SELECT() statement to conditionally select rows, and then summing across those.
From your screenshots, it looks like you are trying to sum everything in column D from the Arel Besin Takip table when the condition of the column B value matches the Tarihi Giriniz value in the Toplam table. If this is correct, your formula will follow this structure to achieve a sumif:
SUM(
SELECT(
Arel Besin Takip[Column D Name],
[Column B Name]=[_THISROW].[Tarihi Giriniz]
)
)
Note you will need to check the spelling and input the proper column names.
thanks @Jonathon now i use this formula for my apps
I write this formula but dont work app or i could not ?
Hello,
If you shared editor access with me I could create the virtual column for you, as an example (share access with Jonathon.Sinclair@snclavalin.com)
Otherwise, @LeventK may be better suited to walk you through the steps in Turkish!
I was able write this formula, but for โTOPLAM MฤฐKTAR CCโ column
How i can write this formula for " Formal " column ," Saฤฤฑm " column and โAnneโ column
Formal,Anne,Saฤฤฑm columns shoul do sums according to Arel Besin Takip Sheet โBESฤฐN รEลฤฐTฤฐโ column
same sums
@brktfkc could you share your table structure and provide more detail on which columns you are wanting to sum, and on which criteria?
Otherwise, the general pattern for what you are trying to achieve is
SELECT( SumTable[SumColumn],
[SumTable_CriteriaColumn] = [_THISROW].[CriteriaColumn]
)
i want sum Formal, Saฤฤฑm and Anne by the date(Tarih Giriniz) entered
for example
in Arel Besin Takip sheet
Saat Tarih Besin รeลiti Miktarฤฑ
17.49 17.01.2020 Formal 30
18.50 17.01.2020 Formal 60
20.30 17.01.2020 Anne 20
21.40 17.01.2020 Anne 50
22.30 17.01.2020 Saฤฤฑm 75
00.00 17.01.2020 Saฤฤฑm 35
in Toplam Sheet
Tarih Giriniz Formal Anne Saฤฤฑm Toplam
17.01.2020 90 70 110 160 ( only Formal + Anne )
(30+60) (20+50) (35+75)
It will be this way
@brktfkc
Burak Bey,
Girilen tarihe gรถre bu toplamlarฤฑ ayrฤฑ ayrฤฑ almak iรงin:
FORMAL
SUM(
SELECT(
Arel Besin Takip[Miktarฤฑ],
AND(
[Tarih]=[_THISROW].[Tarih Giriniz],
[Besin รeลiti]="Formal"
)
)
)
SAฤIM
SUM(
SELECT(
Arel Besin Takip[Miktarฤฑ],
AND(
[Tarih]=[_THISROW].[Tarih Giriniz],
[Besin รeลiti]="Saฤฤฑm"
)
)
)
ANNE
SUM(
SELECT(
Arel Besin Takip[Miktarฤฑ],
AND(
[Tarih]=[_THISROW].[Tarih Giriniz],
[Besin รeลiti]="Anne"
)
)
)
TOPLAM
SUM(
SELECT(
Arel Besin Takip[Miktarฤฑ],
AND(
[Tarih]=[_THISROW].[Tarih Giriniz],
OR(
[Besin รeลiti]="Formal",
[Besin รeลiti]="Anne
)
)
)
)
รOK SAฤOLUN LEVENT BEY @LeventK sonunda halledebildim teลekkรผr ederim.
Rica ederim Burak Bey, kolaylฤฑklar dilerim.
hocam bi de bir ลey soracaktฤฑm appsheetin eฤitimini nasฤฑl alabilrim siz galiba kurucu ortaklardansฤฑnฤฑz ve ayrฤฑca bu eฤitimi aldฤฑktan sonra online olarak eฤiticilik yapabilirmiyim รงeลitli enstitรผ sertifka programlarฤฑnda
Burak Bey merhaba,
Ben kurucu ortak falan deฤilim, sadece bir geliลtiriciyim. Ortaฤฤฑ olduฤum ลirketim AppSheet Developer Partner, ama o ayrฤฑ bir mesele. Eฤitim almak istiyorsanฤฑz ben eฤitimini verebilirim size elbette. Bana levent@able3ventures.com mail adresinden ulaลabilirsiniz. Sevgiler, selamlar.
Tamamdฤฑr levent bey teลekkรผrler
Rica ederim Burak Bey, kolay gelsin, iyi geceler.
User | Count |
---|---|
32 | |
31 | |
30 | |
19 | |
17 |