Sumifs formula dont work in appsheet

Hi, i use sumifs formula my excel table but dont work in appsheet application

like this picture ;

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?

1 Like

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.

3 Likes

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 ?

thanks @Jonathon now i use this formula for my apps

@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─▒.

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! :smile:

1 Like

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

1

same sums

@Jonathon

@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

@Jonathon

1

@Jonathon

@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