LinkBack URL
About LinkBacks
rick434 
Please confirm which column needs to be added in sum? where is that data exist in your file
Please confirm which column needs to be added in sum? where is that data exist in your file
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
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)
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