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?
Bookmarks