Counting in EXCEL Closed

Question

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

aquarelle · Accepted Answer

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 · Answer

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.

Counting in EXCEL

2 responses

Similar discussions

Subscribe To Our Newsletter!