Thread: sum "like"?
View Single Post
  #1   Report Post  
Pablo
 
Posts: n/a
Default 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!