Summing Question

Giganews Newsgroups
Subject: Summing Question
Posted by:  Jimmy (nospam@nospam.com)
Date: Wed, 24 Jan 2007

I have a question:

If I have two columns such as:

9.5    2
3.6    3
14    1
22    1
8      2
9      3
7      1

How would I sum all of the numbers in column A that correspond with a
1 in column B?  Of course I want to the same for 2, and 3 also.

Thanks.

Replies