sum "like"?
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!
|