Searching a string and returning a sum

[cyd000]

I am trying to sum by cost center and account. Where I have several different cost centers that can reference many accounts. I have about 40,000 line items that I need to sort and sum.

the string I am trying to reference looks like this:
262.503.06.00.000
111.503.06.00.000
353.503.06.00.000
262.501.01.00.000
111.501.01.00.000
353.501.01.00.000

The first 3 digits are the cost center (which determines if it is an operating expense, administrative or maintenance expense) and the next 3 are the account and the next 2 are the sub-account.

Is there a way to get Excel to look at the first 3 sets of numbers in the account number and then sum them by cost center?

<colgroup><col width="134"></colgroup><tbody>
[TD="width: 134"][/TD]

</tbody>

 

[Michael M]

I don't quite follow your logic....but have you considered using Text to Columns to split the data then use a Pivot Table to SUM / COUNT the accounts ???

 

[Aladin Akyurek]

Let column A house cost center, etc. spacifying strings, B the values to sum.

If C2 houses 111, C3 262, etc., try...

=SUMIFS(B:B,A:A,C2&"*")

If C2 houses 111.503.06.00.000, etc. invoke...

=SUMIFS(B:B,A:A,LEFT(C2,3)&"*")