Good evening all,
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,
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:
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)