Home

Sumif formula need help

tonka612
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
found it!
=SUMIF(range,"*text*",sum_range)
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies