Find and sort data

**yING** · 03-30-2009, 07:41 AM

Hello,

I am trying to find out the summed up value for CN, DE, US in an unsorted workbook.
I have attached a sample file for your easy reference.
CN, DE and US are in a non-sorted list with different values every time.
These values need to be summed up, consolidated into one value.
I tried lookup(), but as you can see, it only returns the last value of the list.
Is there a way to sum up all values of the list?
Of course I should also mention that only CN's are to be summed up with CN's. So as to receive the total of all CN's. The same goes for DE and US.

Best Regards,

Lennart

**NBVC** · 03-30-2009, 07:48 AM

Try:

=SUMIF($A$1:$A$7,F1,$B$1:$B$7)

copied down.

**zbor** · 03-30-2009, 07:48 AM

Try in G...

Please Login or Register  to view this content.

**arthurbr** · 03-30-2009, 07:50 AM

Hi and welcome to the board
Try =SUMIF(A1:A7,"cn",B1:B7)

**yING** · 03-30-2009, 07:53 AM

HaHa Great!

Now I got 3 working solutions.
Many thanks people! And I am happy to be on-board.
Kind of new to Excel, and this forum has helped me develop over the last few weeks. Great work, keep it up.

**zbor** · 03-30-2009, 08:03 AM

Don't forget to make this thread [closed]

**mudraker** · 03-30-2009, 08:06 AM

Your post does not comply with Rule 9 of our Forum RULES. If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit. And please never edit a thread in which someone else has responded.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save