Sum Product Errors in Excel Errors
I have this formula and it is giving me grief, I keep getting errors (#DIV/0!). I have checked online and apparently sum product does not like blanks. I was wondering if someone could help me out on how I can get sumproduct to skip the blank cells.
Basically column M is a list of orders while N is a list of the total weight of those orders. I need to sum the orders column if (Charge Weight/Orders) is greater than 85. so basically IF CHARGE WEIGHT "divided by" ORDERS>85 then sum. Hopefully this makes sense.
Also Note, this is just a sample data, the actual data can be thousands and thousands of rows.
1 Answers Sum Product Errors in Excel Errors
There is a number of ways of doing it, the simplest one would be: