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))
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
rick434 
Register To Reply
Bookmarks