Appsheet Episode 14: How to sum up values in your table

Hi, thanks for watching this video about Google Appsheet!
In this video we’ll walk you through:

- Sum up multiple numbers
- Use AND( ) expression for multiple conditions

Formula used in this tutorial :

SUM(Employee Data[Salary])

SUM(SELECT(Employee Data[Salary],[JOB]="PMO"))

SUM(SELECT(Employee Data[Salary],AND([JOB]="PMO",[COUNTRY]="United States")))

______

ABOUT THIS CHANNEL
My channel is about Technology and General videos. We cover lots of cool stuff such as Appsheet tutorial, highlights and day to day stuff.

Don’t forget to subscribe!

[muhammadfirdaus]

Bg, kl mw sumif nya muncul di header sesuai dengan filter kita gmna ya?

[ahmadebadi]

Thanks for the video! How should the expression in the Security filter look like? This is what I am really struggling with.

[kokolokostudio]

I saw your expression for SUM and it is very hard coded. What if I have all countries from the whole world (~195) and I want to make SUM for each of them. How to make this expression more dynamic?

[hilelioyuncu-cheatgamer]

Hello, how can I make the application formula write the user's name or e-mail in another column if the value in one column changes?

[neverlosehope]

Brother, how can i get 4 columns total ??

[raffaeleitaly]

Hi, is it possible to kindly see an example of an App with two skill descriptors (or two products for example ) to which the user assigns a score and the App calculates the average by assigning a vote?

[rofadilhox]

what expression should i use to filter salary by month? lets say PMO for Jan 2022, Feb 2022 and so on.. thanks in advance

[aayasir]

Could you please guide me on how to sum based on the month?

For example, I want to some all the values if they are of October.

[spicyworld]

hello there, im a newbie in appsheet. and im a bit confuse with sum expression and virtual column also. Just make sure : I need a virtual column to calculate totals with a sum expression, so if I have created a total column in Google Sheet, that column doesn't work? so that the total column is created later when in the appsheet ? Thanks before

[arunkumarc]

hey there, i have been using this expression to get the total value of the billed items in invoice app...SUM ( SELECT (Invoice List of Items[Total Price], [Invoice ID] = [_THISROW].[Invoice ID])) but it always showing 0 no values where generated...plz do help me..

[BDansmanlk]

hi .ı am from turkiye. ı learned appsheet from of you. thanks you so much

[spicyworld]

so, everytime i want to count my total data, i need to make a virtual column first ?

[ΜέλιτοςΓη]

Hello Aris. The video was very helpful. I came up at a difficult point although. I have created a virtual column to sum the column SalesValue for a table Sales with a condition only for the value "Kalathas" that belongs to the enum (list) column Salesman.

I tried this:
=sum(select(Sales[SalesValue], IN("Kalathas", Sales[Salesman])))
but it results with the overall sum.

Please advice!

[شركةربوعلخدماتالمعتمرين]

Hello brother, thank you very much for your wonderful explanations
Brother, I want to know how I can add a button to display daily records, daily movements, and so on
Can you give us an explanation please, thank you

[hilelioyuncu-cheatgamer]

It will take action if the value changes, if the value does not change it will remain the same

[YeyoOnTrip]

Hi, how can you sum only the selected rows from a Enumlist?

[pritammondal]

if Salary sheet updated, is it possible to automatically update sum of salary?? is yes please describe how.

[gszrzqx]

Thank you so much for your great videos. I am new on Appsheet. I am watching all videos from the beginning. it's very useful. It' just as short and as complete as needed.
I just had some troubles with this SUM(SELECT(Employee Data[Salary], [JOB]="PMO")) formula. I used the Data Explore to select the right Columns in my app and it gives me something like that: SUM(SELECT(Employee Data[Salary], Employee Data[JOB]="PMO")) with the error message: "Cannot compare List with Text". It made me crazy. I finally understood that I had repeated the table twice and this is not a good idea. deleting the 2nd "Employee Data" was enough to solve the problem 😅

[mfuadj]

Thanks for the tips bro. Ive been watching most of your informative and easy to follow videos. Thanks. Just to ask, can i use SUM let say to Calculate "total visit for each unique ID person" using this method? or is it better i put an extra column in the Google Sheet files for this kind of data.

[juanjoge]

Thank you very much, very good tutorial, two questions, 1.- how is the view of compnay? 2.- if you wanted to present them without having to enter a detail, ie the 3 data on a single screen for use in a dashboard, how would the view? as well as condition it by dates, in my case I have several transactions per day and I want to get the totals by category, Thanks in advance for your help