Count Numbers in Column Sharepoint

[MelvinGRM]

Hi, 

I want to make a inventory gallery. So i have one list with items that i want to sum/count, but the code that i use gives an transport warning. Anyone a idea how to fix this? 

The code that i use: 

Sum(Filter(Uitgeleend;ThisItem.Titel="Titel");"AantalUIT")

My SpList: 

 

So i want to filter on titel (and count/sum the red column and display the answer in the a record galllery label on my app.

 

If there are other ways that are easier, please let me know.

Thanks! 

[eka24 · Accepted solution]

Insert a Textbox1 and in the Default:

Sum(Filter(Gallery1_1.AllItems,Title="AT Pro"),AantalUIT)

Or

Sum(Filter(Uitgeleend; Titel = Gallery1.Selected.Title);AantalUIT)

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[MelvinGRM]

Thanks! It works 🙂 

[eka24]

Which of them did you prefer

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[MelvinGRM]

I did this: 

Sum(Filter(Uitgeleend; Titel = ThisItem.Titel);AantalUIT)