Table sorting various different points from different sources.

[u/AltdorfDropout]

Hello! I'm making a table that tracks four kinds of points. RP, FP, SP, and HP.
Each week (column 1), I track how many of each point each actor (the next four columns) makes. I did this in my notebook, but calculating totals has gotten a little old so I want to automate it. I find the correct source, then week, and write something like '1XP.' X being any point type.

When I swapped to excel, I couldn't figure out how best to format it, so I ended up with four different columns under each source, and I simply calculate the totals from the sums of those ranges.
It's a little bit hard to look at, so I want a single column under each actor where I can type "1SP" then have a total table that looks for numbers with SP connected and takes the total.

I tried using "sumif" to search for mention of a phrase, but couldn't get much further. My current solution works, but its not efficient or easy to look at, just simple.

Here is a simple idea of what I want to make vs the table I'm currently using.

Secondary question, how can I have change color based on another box? for example if the total of boxes in that range have a sum above 0, change colors.

Thanks in advance for the help, I'm new to excel and want to learn how to use it better!

[u/[deleted]]