Template
SUMIF and COUNTIF
This app shows how to do SUMIFs and COUNTIFs in AppSheet
Industry:
n/a
You can do SUMIFs and COUNTIFs in AppSheet by combining a SELECT expression with a SUM or COUNT expression. Try changing the Color Choice in the app to see how the values change.
Loading...
Also see:
tablet mode & fullscreen mode
How we built this app
We've got a table of data with a Quantity Column and a Color column.
We first created a SELECT expression that returns all quantities in the Data table that have the same color as the Color Choice column. We put this in a virtual column called [Selected Quantities].
Then, we applied the COUNT and SUM functions.
By combining a SELECT with a COUNT or a SUM, you can get the same behavior as Excel's COUNTIF and SUMIF.
This is a preview of the data sets used in the app.
Data
This is a high-level model of both the data entities and the UI elements in the app.
Loading...