"Sumif" for text

[Stan]

Hi,

I've used "sumif" to pick up certain entities from a large
schedule. Is there a way to pick up related text (not
numbers) in the same manner?

For example,
sumif(A:A,a1,F:F) where A:A is list of entities, F:F is
numbers. I need to also pick up the remarks in column G:G
related to numbers in F:F.

Thanks for your help.

Stan

 

[Frank Kabel]

Hi Stan
and how do you want themto be displayed if there are more than one
matches?

 

[Guest]

You can use " " to pick up text.

=sumif(a1:a26,"total")

 

[Guest]

Frank,

I don't think there will any duplicates.

-----Original Message-----
Hi Stan
and how do you want themto be displayed if there are more than one
matches?

--
Regards
Frank Kabel
Frankfurt, Germany



.

 

[Frank Kabel]

Hi
if there could be only one row which matches the search criteria use
=VLOOKUP(search_value,A1:G1000,7,0)

 

[Stan]

Frank.

Let me try to explain again.
The w/p I'm putting together (file#1) has 500 entities and
the original w/p (file#2) has about 25,000 entities.

In file#1, I need to pick up a number from column F:F in
file#2, and also need to pick up a related text in column
G:G in file#2 if any of the entity numbers in column A:A
in file#2 is "123".
I can use "sumif" to pick up numbers, but I need a similar
function for non-numeric contents.
The number and the text are located in the same row.

Please help.
Thanks

 

[Frank Kabel]

Hi
if you only expect one match VLOOKUP should work. If there could me
more than one match you have to explain how you wnat to combine these
results.
You may post some example rows of both files (plain text - no
attachment please) and describe based on this example your expected
result