Forum Discussion
Item Amount Bread 50 Donuts 100 Cookies 40 Cakes 50 Pies 20
can anyone tell me how to use the SUMIF formula here and get result 160
2 Replies
=SUMIF(data_range,"*e*",amount_range)
Try thisyou could =SUMIFS(Table1[Amount], Table1[Items], "*e*")
