Searching result from list based on criteria

I have rows from googlesheets saved as a variable. The table got few heads. Year, cost, name of the car. The table will show the service cost of some cars.
I wanted to know if it is possible to search service cost based name of the cars, year etc..
Such as total cars made on specific year,
Average service charge for specific model of car every year.

yes you can...
use the Google Visualization API, see an example here App Inventor Tutorials and Examples: Google Spreadsheet Database | Pura Vida Apps


Trying to push the limits! Snippets, Tutorials and Extensions from Pura Vida Apps by icon24 Taifun.