How to sum durations of multiple set lists within one song list

Hi all.

I'm trying to use Numbers for organizing a list of songs (with titles in one column, durations in another, and additional song data in other columns) into “setlists” (musicians' term, not computer programmers' term), such as Set 1, Set 2, Xmas Set, Valentine’s Day Set, etc. A screenshot is below.

Here’s my goal: I’d like to see a live-updating duration of each setlist as I add or subtract songs to various sets. (**Importantly, some songs are in multiple setlists.**) Got me so far? I'm trying to figure out the best way to do this. It seems like it should be a fairly simple thing to do. I just can’t figure out how to set things up so that it’ll work.

Currently, each song's title is in column “A” and its duration is in column "I" as a number, such as 2.5. I currently have a column for each set (Column B is Set 2, Column C is Set 3, etc.) with a number in the appropriate column, that will show the order of songs within the set. If a song is in Set 1, within the Set 1 column (“B”), there's a number between 100 and 199; if a song is in Set 2, there's a number between 200 and 299 within the Set 2 column (“C”) that shows where it falls in the set, etc.

I tried making a formula in each setlist’s column header that says, more or less, “If there’s anything in this setlist’s column (B, C, etc.), include the duration in the SUM in Column “I”… otherwise, 0. But it adds ALL songs durations, not just those in the given setlist. IF(NOT(ISBLANK(B4:B235)),SUM(I4:I235),0) 

Should I be using Categories, Sort, and/or Filter instead… or in addition? I’m less familiar with these. (I’m more of a Filemaker Pro guy, but it seems like overkill for this task, and I would like to use Numbers if possible.) Or some other approach, such as multiple “Sheets”? I’d prefer not to use multiple sheets so that I don’t get taken to a different sheet when I search for a song title.

Thanks for any input. Much appreciated.

Edly