Formula Problem - Recognizing text and returning other info

  • Thread starter Thread starter profusek
  • Start date Start date
P

profusek

I'm trying to figure out a function that will allow me to recogniz
repeated text in a column and when it finds it, return a specific piec
of information from 1 or more other cells (text or numerical value)
Also, if it is a value... have the ability to sum the values for eac
time it runs into the same text in the column.

Example: A B

AZ 1000
BG 200
AZ 1500

Search column "A" for each AZ.
Return the value in column "B" and sum it up

AZ = 2500
--------------------------------------------------------

or A B C D

AZ OHIO RED DOG
BG NY BLUE CAT
AZ NJ BLACK RAT

Search column "A" for each AZ
Return the text in "B" "C" and "D"

AZ = OHIO RED DOG
NJ BLACK RAT

I am extremely stuck on this and any help would be greatly appreciated
Thanks in advanc
 
=SUMPRODUCT((A1:A0="AZ")*(B1:B10))
will do the sums, not quite sure what you mean about the text values,
Regards,
Alan,
 
Sorry, Typo
=SUMPRODUCT((A1:A10="AZ")*(B1:B10))

Alan said:
=SUMPRODUCT((A1:A0="AZ")*(B1:B10))
will do the sums, not quite sure what you mean about the text values,
Regards,
Alan,
Click to expand...
 
Back
Top