The first SUMIF function adds up the Apples sales, the second SUMIF sums the Lemons sales. Where A2:A10 is the list of items ( range), B2:B10 are the numbers to sum ( sum_rage), E1 and E2 are the target items ( criteria): Or you can enter the criteria in separate cells, and refer to those cells: For this, you can supply the items of interest directly in the criteria arguments of 2 different SUMIF functions:
In the table below, suppose you want to add up sales for two different products, say Apples and Lemons. SUMIF(range, criteria1, sum_range) + SUMIF(range, criteria2, sum_range)
