=SUMIF(A:A,"001-*",B:B)

HTH
Jason
Atlanta, GA

-----Original Message-----
Is there a function or array that can sum anything
like "001-"?

For example, I have a list of #s such as:

001-001
001-004
002-001
001-005
004-001

in a column, and the next column list values such as:

$5
$7
$9
$10
$3

How can I sum everything that is like "001-"? So sum 001-
001, 001-004, and
001-005?

Thanks!


.