Here's another one:

=SUMIF(A1:A9,1,B1:B9)

Rick...I'm trying to rate your post too and they don't make it that
easy. I will figure that out.

I'll rate it for you.


--
Biff
Microsoft Excel MVP


"Mark B." wrote in message
...

Rick,

Thanks a TON. I'm trying to rate your post too and they don't make it
that
easy. I will figure that out.

Mark

"Mark B." wrote:

Hi,

I feel like an idiot but I couldn't do something that should be easy. I
have columns in a spreadsheet like the ones below. I want to find all of
the
items with a "1" in the left hand column and total the corresponding
values
in the right hand column. I've been trying to figure this out with one
of
the lookup features and I'm lost. Can somebody help? Thanks a ton.

1 16
1 10
5 48
1 15
3 41
1 26
3 42
3 34
1 22