Counting in EXCEL

Closed
Excel - Dec 9, 2008 at 02:18 AM
TheParoxysm Posts 169 Registration date Sunday December 7, 2008 Status Member Last seen March 25, 2011 - Dec 9, 2008 at 02:01 PM
Hi

Having a problem,
I want to count the number of cells that starts with a certain figure,

Example

90500-3
90400-3
400000-3
50000-3
30000-5

I want to count the number of cells that starts with 90, how do I do that in Excel.

Thanks for any help
Related:

2 responses

aquarelle Posts 7141 Registration date Saturday April 7, 2007 Status Moderator Last seen December 19, 2024 491
Dec 9, 2008 at 01:02 PM
Hello,
If I suppose that your data are in the column A like above and that you want to get the result in A7, you have to put the following formula in A7 =COUNTIF(A1:A6;"90*")
               A                  B
1            90500-3
2            90400-3
3            400000-3
4            50000-3
6            30000-5
7           =COUNTIF(A1:A6;"90*")


Now, you have to adapt it to your problem. Hope this help you.
Best regards
TheParoxysm Posts 169 Registration date Sunday December 7, 2008 Status Member Last seen March 25, 2011 74
Dec 9, 2008 at 02:01 PM
Or if they are scattered you could just put it out normally =COUNTIF(A1, B2, C3;"9.0*")
TheParoxysm Posts 169 Registration date Sunday December 7, 2008 Status Member Last seen March 25, 2011 74
Dec 9, 2008 at 12:15 PM
I know you're going to need to use wildcards. Other than that, I'm sorry. This is a job better suited for a database.