Excel, Data, Data Analysis, Analytics.
up the sales amounts for jeans. To do so, I include “Jeans” as the criteria: =SUMIF(A2:A6, “Jeans”, B2:B6) “SUMIF” adds values based on certain criteria. “A2:A6” is the range that contains the criteria. “Jeans” is the criteria I want to match. I’m only interested in summing sales for jeans. “B2:B6”