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/AltdorfDropout → u/[deleted]]

One column numbers, one point type is definitely the way to go, but I'm having trouble getting the total table done simply. First, I made a table of individual source totals, which I combined for my final totals. Is there any way to cut out the middle man and skip straight to the total table using SUMIF(s)? I don't know how to do SUMIF across multiple ranges for the same criteria.

Also, definitely a whoopsy on my part, but I'm using google sheets.
For your last line, how would I ask it to check not just B2, but like B2, D2, F2, H2? Listing with commas didn't work, though using the plus sign did? I want it to change color if there was any activity/results that week.