=SUMIFS(range_with_sum_value,criteria range_1,criteria_range_1_value,criteria range_2,criteria_range_2_value)
E.G.:
Looking at the formula below. Column A is the sales prices column. Column B is the types of products bought. Column C is the number of orders. The formula below is establishing the total sales price for Cakes that were bought more than once in each order.
=SUMIFS(A2:A9,B2:B9,"Cakes",C2:C9,>1)
Cells A2:A9 in the formula is the range to sum. The statement, 'B2:B9,"Cakes"' bases the cells being added up in cells A2:A9 solely on the related rows that say Cakes. The final statement, '>1', specifies to the formula to select those prices where the cake orders were greater than 1.
E.G.:
Looking at the formula below. Column A is the sales prices column. Column B is the types of products bought. Column C is the number of orders. The formula below is establishing the total sales price for Cakes that were bought more than once in each order.
=SUMIFS(A2:A9,B2:B9,"Cakes",C2:C9,>1)
Cells A2:A9 in the formula is the range to sum. The statement, 'B2:B9,"Cakes"' bases the cells being added up in cells A2:A9 solely on the related rows that say Cakes. The final statement, '>1', specifies to the formula to select those prices where the cake orders were greater than 1.
