| Home |
| Search |
| Today's Posts |
|
#3
|
|||
|
|||
worked great! Thanks!
"Jason Morin" wrote in message ... =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! . |
Threaded Mode
