Sumif formula need help

Highlighted
New Contributor
2/9/18               10.383371 EL POLLO LOCO       LOS ANGELS  CA
2/17/18               16.183372 EL POLLO LOCO       LOS ANGELS  CA
1/1/18                       45705 FASTRIP #641         LOS ANGELES  CA
1/1/18                       51706 FASTRIP #641         LOS ANGELES  CA
2/5/18               52.97707 FASTRIP #641         LOS ANGELES  CA

 

trying to categorize expenses, thinking I could use sumif to look at a column and sum all the expenses for El Pollo, Fastrip, etc., but it doesn't seem to work.

Is there another formula I could use.

Thanks.

1 Reply
Highlighted
found it!
=SUMIF(range,"*text*",sum_range)