Forum Discussion

Copper Contributor

Apr 09, 2025

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

Formulas and Functions

Copper Contributor

Apr 10, 2025

=SUMIF(data_range,"*e*",amount_range)
Try this

Resources