bill05

very easy!!
you can use the (sumif) function
in your case,
for $100:
=SUMIF(B1:B6,100,C1:C6)
for $50
=SUMIF(B1:B6,50,C1:C6).....etc

[ 本帖最後由 bill05 於 16-1-2009 01:36 編輯 ]