SUMIF Working but SUMIFS not working :(

Please anyone help me! I am creating a workbook for my upcoming wedding and obviously Im a type A sort of person who needs EVERYTHING analyzed lol.

I have done SUMIF to each of the criteria that I want to use with the SUMIFS, which do work; however, I get a #VALUE! when i try to put them both together and do SUMIFS. I use to have the criteria as a drop down list for each Side and RSVP Status too (data validation list), which I thought was the problem. But it remained like this even after I made this into regular text. Ive made sure they were labeled as text in the formatting, Ive made sure there was no extra spaces, etc.

PLEASE PLEASE HELP, IM BEGGING!

Also bonus points to help me to get it to work with my drop down lists too :) Thanks for your smart minds

This does not work... I want it to be the sum of total guests permitted with the criteria of Side (like bride vs groom) + RSVP Status (Attending vs Not Attending vs No Response)

SUMIF Side works

SUMIF RSVP status works