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