A Worksheet Has the Following Data in It: Cell Range

A worksheet has the following data in it: Cell range A2 to A10 in column A lists the categories of food items in a store: Vegetables and Fruits.Cell range B2 to B10 in column B lists the types of food items for each category: Cucumbers,Corn,Pears,Lettuce,Potatoes,and Scallions.Cell range C2 to C10 in column C lists the sale of each item during the month.If we insert the formula =SUMIFS(A2:A10,B2:B10,=P* )in cell A11,it will give us the total sale of products that begin with the letter P.