Forum Discussion
Sum IFs question
I'm building a spread sheet at work to calculate the sum of weights. Column B has all of our "truck loads" weights that contain NO brick. Column B has all of the "Truck Loads" Total weight (WITH ...
If as regular formula without CSE
=SUM($E$6:$E$20) +
SUMPRODUCT(
$C$6:$C$20 * ($C$6:$C$20 > $E$6:$E$20)
)