How to Subtotal values that begin with a letter?

[sstendahl]

Hello everyone,

I have an issue with Excel 2007.

I am able to use the subtotal function to get a dealer number for a column. If the dealer number begins with a C, my subtotal function errors with the #DIV/0!


In my sample spreadsheet, if you filter just one dealer number, the forumula in A18 will work. If you switch to the last dealer C1221 it errors because of the letter. Any help would be appreciated or other methods to get this done.

Thank you!