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
TheParoxysm Posts 169 Registration date Sunday December 7, 2008 Status Member Last seen March 25, 2011 - Dec 9, 2008 at 02:01 PM
Related:
- Counting in EXCEL
- Number to words in excel - Guide
- How to take screenshot in excel - Guide
- Dd-mm-yyyy format in excel - Guide
- Excel free download - Download - Spreadsheets
- Excel marksheet - Guide
2 responses
aquarelle
Posts
7140
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
March 25, 2024
491
Dec 9, 2008 at 01:02 PM
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*")
Now, you have to adapt it to your problem. Hope this help you.
Best regards
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 12:15 PM
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.
Dec 9, 2008 at 02:01 PM