It did? For the rows you told me you had your data in? Really?

Rick


"Gregory Day" wrote in message
...
This one nailed it, and oh so elegant!
--
Thank you,

Gregory


"Jim Cone" wrote:

Another...
=SUMIF(Sheet2!B1:B11,"=Level 3",Sheet1!B1:B11)
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Gregory Day"
wrote in message
I really hope you guys can assist me. I need a formula that will add up
the
number in Sheet1, ColumnB for each person who has "Level 3" next to their
name on Sheet2. That is Dave, Greg, Jeff, and Tony.
The result should equal 51.

Sheet1
A B
1 Adam 15
2 Dave 12
3 David 16
4 Donna 16
5 Gregory 12
6 Jeff 13
7 Steve 16
8 Tony 14
9 Juan 0
10 Hamilton 0
11 Jeremy 0

Sheet 2
A B
1 Adam Level 1
2 Dave Level 3
3 David Level 2
4 Donna Level 1
5 Gregory Level 3
5 Jeff Level 3
7 Steve Level 1
8 Tony Level 3
9 Juan Level 1
10 Hamilton Level 1
11 Jeremy Level 1

Does anyone have an idea of how this can be done?
--
Thank you,
Gregory