Help on SUMIFS and COUNTIFS

Thank You, those formulas helped. However, I want to get to the crux of my problem here so I have attached a full example rent roll as it appeared when I downloaded it.

This property has 16 "Units" as seen in the upper table. However, when I substitute another property into this template, it might only have 10 "Units". This will cause a problem where the far right table with "Annual Rec", "Annual Rent Plus Rec / Area" and "Annual Rent Plus Annual Rec" will have some rows that are "dangling" (it works for this property because that far right table just adds horizontally from the main table) and the summations don't work.

I need to be able to copy and paste from an entirely separate spreadsheet a different property's rent roll into this template and have the lower table and the far right table automatically update their info (and in turn have the bar graph automatically update as well) even if the new property that was pasted in has less (or more) units than this property does in the template I have provided.

The most important part is that the "Total Area", "Total Annual Rental Revenue", "% Area", "% Revenue" and "Avg Rent PSF (Gross)" rows in the lower table are equipped with formulas that will allow a new property's rent roll to be pasted into this spreadsheet and have them automatically update.

I should note that the formulas in the "Total Area" and "% Area" rows from the lower table have already been addressed in this same thread, so the current problems are with the far right table and the other 3 rows in the lower table.