easy5 pts · first answer countsexcelformulas
SUMIFS with two conditions
Rows (Region, Product, Sales): (East, Pens, 100), (East, Books, 200), (West, Pens, 150), (East, Pens, 50). What does =SUMIFS(C:C, A:A, "East", B:B, "Pens") return?
Discussion 0
Join free to post in the discussion.
Related questions
- What a pivot table doesData Analyst
- Absolute references in ExcelData Analyst
- VLOOKUP returns wrong pricesData Analyst
- Lost leading zeros in IDsData Analyst
- Looking up a value to the leftData Analyst
- Share of sales in a pivot tableData Analyst
- Pivot ignores new data rowsData Analyst
- Same cleaning every MondayData Analyst