How to get Count & Sum

How to get count IF I choose “Z” from 1 to 6
& How to get Sum IF I choose “Z” from 16
Count &Sum request

Is this data in gsheet or Excel? Where is Z 16?

1 Like

try the sqlite component

Taifun

This post was flagged by the community and is temporarily hidden.

I want the building blocks that achieve this

Use the math blocks, you can find the Math drawer

A very good way to learn App Inventor or Kodular is to read the free Inventor’s Manual here in the AI2 free online eBook App Inventor 2 Book: Create Your Own Android Apps … the links are at the bottom of the Web page. The book ‘teaches’ users how to program with AI2 blocks.
There is a free programming course here Course In A Box and the aia files for the projects in the book are here: App Inventor 2 Book: Create Your Own Android Apps
How to do a lot of basic things with App Inventor are described here: How do you...? .

Also do the tutorials Tutorials for MIT App Inventor to learn the basics of App Inventor, then try something and follow the Top 5 Tips: How to learn App Inventor

Taifun

3 posts were split to a new topic: I want to display the SUM result of spreadsheet in tableView