I've got 2 columns of information. The first column is text. The second column is numbers. I'm trying to create a formula that will lookup and search a criterion contained in the text column and return the number in the corresponding row. Problem is that many of the rows contain the text I'm searching for. I need the formula to return all the corresponding numbers added up?!?!?
See attachment for an example.
=SUMIF(A4:A25,"=*18a*",B4:B25)
=SUMIF(A4:A25,"*"&C1&"*",B4:B25) where c1 contains 18a
or
=SUMPRODUCT(--(ISNUMBER(SEARCH("18a",A4:A25))),B4:B25)
Mojito connoisseur and a dabbler in Cisco
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
This is going to work perfectly, thank you!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks