Difficulty 2 of 5 · about 3 min
Total sales for one region and one category with SUMIFS
Sales rows are in A2:C11: region in column A, product category in column B and sales amount (INR) in column C. The region to report is typed in E2 and the category in F2. In G2, write a formula that adds up the sales amount only for rows that match BOTH the region in E2 and the category in F2.
Loading grid…