Adding certain numbers based on...
 

I have 2 columns of numbers. the first column contains phase numbers, the
second column contains amounts. I need to sum (add) all the numbers in the
second column which correspond to a certain number (repeated several times)
in the first column.

6.1 $15.05
4.2 $19.23
9.1 $42.00
6.1 $57.50

In the example, I need to add all the amounts for phase 6.1, in this case,
equalling $72.55. Thanks for any help.

Rich
Rich D
Armstrong Custom Homes
Redmond

Adding certain numbers based on...
 

=SUMIF(A1:A4,6.1,B1:B4). Adjust ranges to suit your needs

"Rich D" wrote:

I have 2 columns of numbers. the first column contains phase numbers, the
second column contains amounts. I need to sum (add) all the numbers in the
second column which correspond to a certain number (repeated several times)
in the first column.

6.1 $15.05
4.2 $19.23
9.1 $42.00
6.1 $57.50

In the example, I need to add all the amounts for phase 6.1, in this case,
equalling $72.55. Thanks for any help.

Rich
Rich D
Armstrong Custom Homes
Redmond