find problems

  • Thread starter Thread starter ivo bodewes
  • Start date Start date
I

ivo bodewes

hello,

I want to let excel find in a range of cels a certain tekst and get the
number in the cel right from that tekst. The tekst is in the range sometimes
more than once. If that is it has to calculate the sum of the numbers in the
cells right from the tekst.

Greets Ivo
 
Hi
not really sure what you want to achieve then more trhan one occurence
exist. Could you post some examples
 
One way ..

Suppose you have in Sheet1, cols A and B, from row1 down

Text1 1
Text2 2
Text1 3
Text2 4
etc

In Sheet2
-----------
Listed in A1 down are the text:

Text1
Text2
etc

Put in B1: =SUMIF(Sheet1!A:A,TRIM(A1),Sheet1!B:B)
Copy down

Col B will return the totals corresponding to the list from Sheet1
i.e. for the sample data it'll show as:

Text1 4
Text2 6
 
Back
Top