Excel, Data, Data Analysis, Analytics.
that contains the criteria. “T-Shirt” is the criteria I want to match. I’m only interested in summing sales for T-shirts. “B2:B6” is the range with the values I want to add (the sales amounts.) I use the SUMIF() formula to calculate the total sales for t-shirts. Next, I want to use SUMIF() to add