sum of a kolumn based on text in an other kolumn

  • Thread starter Thread starter oks
  • Start date Start date
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
 
Back
Top