Sum within indirect instead of having to add extra column INDIRECT("'IPEDSUS'!F2:F"&9000))

A formula like that is hard to follow without some sample data and expected results, and an explanation of what the formula should be doing.

Here's what I get from it.

=SUMIF(IPEDSUS!$E$2:$E$9000,"Public",IPEDSUS$F$2:$F$9000)/SUM(IPEDSUS!$F$2:$F$9000)

Unless there are duplicates in Row 1 and you want to get the result from the left most column with the same matching value, then the rest of your formula appears to serve no purpose.

edit:-

Reading the bottom part of your post again, maybe more like

=(SUMIF(IPEDSUS!$E$2:$E$9000,"Public",IPEDSUS$C$2:$C$9000)+SUMIF(IPEDSUS!$E$2:$E$9000,"Public",IPEDSUS$D$2:$D$9000))/SUM(IPEDSUS!$C$2:$D$9000)

This would be much easier to understand if you could upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.