y number ont of the nent is Among transaction e made by Zare ansaction waarde Product sikur age transaction site is olumn 317 more than $100. what is the total dollar amount of t about transactions of less than $100 he Among transactions Jen? What abou Because the criteria is N order you need to which Jen sold lipstick ameen Product lipsti ipstick transactions in Name "en. Product "lipsti the total revenue Namejen. Product lipstick, and some statement about the do d to use the SUMIFS function. In cell B24compute the in Cell B24. I compute the total amount in transactions stick and the dollar amount was at least 5100 with the formula - SUMIES lipstick", Dollars">100"). Jen sold 53,583 worth of lipstick in such transaction involving less than $100, you can see in cell 25 (the formula is SUMED lipstick",Dollars," 100"). Jen sold 53,583 worth of lipstick in such transaction involving less than $100, you can see in cell 25 (the formula is SUMED lipstick",Dollars,"