Previous Topic Next Topic

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

Answer 1 / 2
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
3
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*")
0
Answer 2 / 2
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.
0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses