TrainityTrainity
All ideas

Sumifs function

Publisher Genre Sales Avalon Interactive Shooter ₹ 116,537.00 Avanquest Puzzle ₹ 182,255.00 Avanquest Software Shooter ₹ 125,010.00 Berkeley Simulation ₹ 153,981.00 Nintendo Racing ₹ 126,309.00 Avanquest Software Sports ₹ 125,010.00 Publisher Genre Sales Avanquest Software Shooter ₹ 241,547.00 =SUMIFS(C27:C32,A27:A32,"Ava*",B27:B32,H27) I understood this. However, my doubt is: Calculate the sales, the condition is the publisher should be starting with "ava*" and the genre should be puzzle and shooter. What will be the sumifs formula for the above condition.