Question: how to sum multiple columns?
Answer: B2:B10, C2:C10 and D2:D10, indicate the columns that you want to sum, if you have more columns data need to sum, just add the column range as your need;
A2:A10 refers to the range of cells that you want to apply the criteria against;
F2 is the criterion that the items are to be added.