sum of a kolumn based on text in an other kolumn

O

oks

Hi
I want to sum up a kolumn based on if a word is found in an othe
kolumn.

ex.

A B
10 Some text
20 Some more text
30 New text
40 even some more text


The I want to sum kolumn A if i can find the word more i kolumn B Th
sum is 60

ok
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formating bolded text exclusively. 0
Weigh tasks 0
Sum Values from different column 1
How do I set focus (and select text) on a text box on a modeless userform? 0
Max/Min per item from a changing list 0
How can the font and size of (all) citation numbers be altered? 1
Automation of scanned file storage based on content 0
Offset, sum down to the first blank row 7

Top