Hi.
In a list of transactions, I want to find those with a certain word included in 1 of the columns, and then add the figure in another column where this word is found.
Thought about using search but have problems with the error when the word is not found.
Any ideas, folks?
Thanks
Last edited by FCFalkirk; 12-15-2010 at 09:07 AM. Reason: solved
Describe your problem with "what I have and what I want"
Better stil attach a spreadsheet containing your work so far.
try
=SUMPRODUCT(--ISNUMBER(SEARCH("mytext",A1:A100)),C1:C100)
oops better still
=SUMIF(A1:A100,"*mytext*",C1:C100)
Last edited by martindwilson; 12-15-2010 at 08:52 AM.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
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
Thank you, kind sir. Your great advice has solved my problem.
Many thanks
Emma
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks