I have a table as follows in Excel 2007


A B C D E
Account Number Account Name Nov-05 Dec-05 Jan-06
1000 $$$$ $$$$ $$$$
2000
3000
4000
5000
6000

Please note that in account numbers, i do have other number in between, I have over 120 unique account numbers.

So I am trying to create a number of formulas based on my data to give me some ratios.

For example all 4000 accounts are sales and I want to do a sumif of anything that start with 4 to get a total sales number.

=sumif(Sheet1!A:C,="4????",Sheet1!C:C)

I also tried with 4* as well.

Both is giving me error messages.

How can I add numbers who start with 4?