LinkBack URL
About LinkBacks
ok here use this one instead, its column B im trying to add up
ok here use this one instead, its column B im trying to add up
Or
Formula:
=SUMPRODUCT(ISNUMBER(SEARCH("subway",E2:E23))*1,B2:B23)
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Awesome Thanks so much to both of you thats exactly what i needed!I wish I understood these functions better. One more question sometimes walmart appears as "WM-supercenter" and sometimes it appears at "WAL-MART" on my statement, is there anyway to make it add those up all together since it is two different keywords, im thinking maybe and "or" function i dunno just guessing
As FDibbins suggested use it like this...
=SUM(SUMIF($E$2:$E$23,{"*Subway*","*Sheetz*"},B2:B23))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks