"Look up" with multiple hits?

  • Thread starter Thread starter Olle Nyström
  • Start date Start date
O

Olle Nyström

There is a range of "look up" formulas that finds a value in one column and
delivers a value from a different column in the same row. But all of them
seemes to be designed to find one specific answer.

I have a column where I mark differnt types of rowes. Let's say there are
ALFA-types and BETA-types. I want Excel to find all the rowes marked ALFA in
column number one (they are not sorted), and add their values from another
column.

This seemes to be so basic that I guess I'm missing something obvious.
Please help me out.

Cheers

/Olle
 
Looks like you want:

=SUMIF(ConditionRange,"ALFA",RangeToSum)

The conditionRange is the range which houses ALFA/BETA-marks.
 
Thank you!!!

If I could only send you a beer... You made my day (or night here in Sweden)

/Olle
 
Hi Aladin

i was looking for an article you wrote on the sumproduct function where you
broke down the process that excel uses, for a question posted to this
newsgroup on feb 25th (title of OP is "Pls Help Me") ... can't seem to
locate the article on your web site anymore. could you pls post a link to
it here (or in the other thread) .

cheers
julied
 
Back
Top