SUM using multiple selections from an enum list

HI friends,

I'm new to appsheet and want to use it for some simple database functions.  For this specific problem I have numerous mentors and partners who volunteer with our non-profit.  I want to sum the hours they volunteer with us based on what programs they volunteer for.  I have a table with the program data and a table with the mentor data and I want one of the columns in the mentor table to sum the hours they have volunteered with us.  In the program table I have a column where I designate how long the program was [hours] and a column where I use Enum Reference to select 1 or 10 or 100 mentors, [partners in attendance].  I want on the partner page to auto sum how many hours they have volunteered with us but I can't quite get the formula right.  In sheets it would be similar to a sumif, but I'm having issues understanding some of the previous answers to other questions.

Talk to me like in 10 as I used to say when asking someone to explain something to me haha!

0 0 33
0 REPLIES 0
Top Labels in this Space