"Look up" with multiple hits?

[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

 

[Aladin Akyurek]

Looks like you want:

=SUMIF(ConditionRange,"ALFA",RangeToSum)

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

 

[Olle Nyström]

Thank you!!!

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

/Olle

 

[JulieD]

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

 

[Aladin Akyurek]

Hi Julie,

Still accessible at:

http://www.mrexcel.com/wwwboard/messages/8961.html

Otherwise:

http://216.92.17.166/board2/viewtopic.php?t=59063

Aladin

 

[JulieD]

thank you

Hi Julie,

Still accessible at:

http://www.mrexcel.com/wwwboard/messages/8961.html

Otherwise:

http://216.92.17.166/board2/viewtopic.php?t=59063

Aladin