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
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
203 Replies