auto.pilot
Well-known Member
- Joined
- Sep 27, 2007
- Messages
- 734
- Office Version
- 365
- Platform
- Windows
In column A, my worksheet is populated with entries like 701-01, 701-04, 701-05, 702-01, 702-03, 703-01, 703-04, etc. Column B contains dollar amounts. There are hundreds of rows.
I'd like a formula that would sum column B by all the entries in column A that start with 701, regardless of the dash or two digit number that follows. A helper column using LEFT could be used to isolate the three digit code, but I'd prefer using a formula and not add a new column.
How can I do this?
Thanks in advance for all replies.
j
I'd like a formula that would sum column B by all the entries in column A that start with 701, regardless of the dash or two digit number that follows. A helper column using LEFT could be used to isolate the three digit code, but I'd prefer using a formula and not add a new column.
How can I do this?
Thanks in advance for all replies.
j