Hello All,
I am using a SUMIFS function and need to add a criteria to determine if specific text is contained within the criteria range.
TYIA
Bjordion
Hello All,
I am using a SUMIFS function and need to add a criteria to determine if specific text is contained within the criteria range.
TYIA
Bjordion
Last edited by Bjordion; 12-05-2011 at 04:28 PM.
Good evening Bjordion
Have you tried using the standard "*" wildcard?
Something like =SUMIFS(A1:A10,B1:B10,"Excel*") would pick up Excel, Excellent, Excellence etc.
HTH
DominicB
Please familiarise yourself with the rules before posting. You can find them here.
Ocham's Razor is proved true yet again. Had completely forgotten about the wildcard.
Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks