Excel. Sum column of a table based on a filter of another column-CodePudding

Say that we have a table with 2 columns (Places, Sales), in column "Places" we have the values Home, Work, Other, and in column "Sales" we have the sales values. I want to sum the values in column "Sales" but only the ones that match the "Home" place. Can I do that without using vba?

CodePudding user response：

This can be done using sumif function. Sumif('select the range of category i.e. Places','select the category i.e. Home','range which needs to be summed i.e. sales')

for the above table if you use the =SUMIF(A1:A7,$D$2,B1:B7) or =SUMIF(A:A,"Home",B:B) you will get your answer as 16.