Hey, Everyone: How can I count the number of...

Jayne_Hawkins · 10-01-2018 05:00 PM

Hey, Everyone:

How can I count the number of occurrences in another worksheet? In my spreadsheet, I have TAB 1, which features a list of courses + the total number of seats available. TAB 2 contains the registrations for each of the courses in TAB 1.

What I need to do is count the number of times a particular course appears on TAB 2 and return that information back to the “seats booked” column in TAB 1.

I’m looking for the total number of seats booked for each particular course. The data will come from TAB 2, but I need the answer to populate in TAB 1.

I can’t figure out what my formula should be… how to reference the other tab… where to enter that formula. Please let me know if I’m not being clear. Thanks!

Lynn

Hi @Jayne_Hawkins Check out COUNT expressions. Something like this. COUNT(SELECT(tablename[columnto count],[course]=[_THISROW].[course] ))

You will have to use your table and column names and any other filters you require.

Suvrutt_Gurjar

I also request you to take a look at a similar sample app mentioned below as your requirement. In the sample app the courses are there. In place of registration,the assignments are there. However principle is same. Assignment table (titled School Work Manager) references Courses table.

Similar to your requirement of getting registration numbers into courses table,the sample app gets “outstanding work” and “Completed Work” data from Assignments table.

Hope this helps.

appsheet.com - Assignment Manager - An app to manage school work and assignments.

Assignment Manager - An app to manage school work and assignments. appsheet.com

Suvrutt_Gurjar

Hi @Jayne_Hawkins,

Based on your description of app functionality you may wish to

consider following.

For ease of getting data from the registration table into courses table and vice versa, have you considered the “Referencing”

between tables?

The registration table could reference the courses table.

I request you to go through following article.

help.appsheet.com - References Between Tables References Between Tables help.appsheet.com