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 ...
I think you want =SUM(IF(E6:E20="",C6:C20,E6:E20))
If you do not have Microsoft 365 or Office 2021, confirm the formula by pressing Ctrl+Shift+Enter.