Ann,

it's sumif

=SUMIF(A1:A4,"=1",B1:B4)

Chane 1 for 2 for the other values.

Mike

"Ann" wrote:

i want to sum the numbers in column B based on the criteria in column A and
give a count. not sure what the combo is.

Col A col b
1 9.99
1 9.99
2 10.00
2 30.00

so i want the result to show
1 19.98
2 40.00