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
you could =SUMIFS(Table1[Amount], Table1[Items], "*e*")
you could =SUMIFS(Table1[Amount], Table1[Items], "*e*")