Excel, Data, Data Analysis, Analytics.
columns: “product (column A)” and “sales amount (column B).” I want to calculate the total sales for each product: t-shirts, jeans, and blazers. To calculate the total sales for t-shirts, I type: =SUMIF(A2:A6, “T-Shirt”, B2:B6) “SUMIF” adds values based on certain criteria. “A2:A6” is the range