I currently ran into an issue, as soon as I solved my last one! (but of course!)

I'm currently using this formula to get information from one sheet to the next,

=TEXT(SUMIFS('Raw Data'!$C:$C,'Raw Data'!$A:$A,"1",'Raw Data'!$B:$B,$A14),"#")

Now, when I go to use "SumProducts" at the end of my sheet it doesn't work correctly unless I take that formula above and divide by 1. Now when I divide by 1, I get a #VALUE error if the cell is left empty.

Is there a reason excel is making me divide by 1 to show a number in my sumproducts cell?

SumProduct formula:

=SUMPRODUCT($B$4:$AY$4,B14:AY14)