LinkBack URL
About LinkBacks
I got the follow problem:
i want to count g7 till g50.
But in some are text.
So i cant count...
How do i solve this problem?
I got the follow problem:
i want to count g7 till g50.
But in some are text.
So i cant count...
How do i solve this problem?
=counta(G7:G50)
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
If you need to count numbers in the mixed range
=COUNT(G7:G50)
Last edited by AlKey; 03-07-2014 at 02:13 PM.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
It works. Thank you
Oh it doenst count :S
It says : 40 but every where i filled in 0
@Extreming you need a better explanation of what you really need. Do you need to count numbers and ignore text or count numbers and ignore 0?
Count number and ignore text
That's because 0 is a number. Leave the cell blank if you don't want the COUNT function to count it.Originally Posted by Extreming
I cant leave it blank..
Because i need it :S
I only want to ignore the text..
Post a copy of the workbook, please. We are going round in circles!
Dutch =AANTAL(C1:C10)
English =count(c1:c10)
This will work, I tested it.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
oeldere it works lol
Ohno it doesnt..
It doesnt count
Ok people i show you
https://docs.google.com/spreadsheet/...Xc&usp=sharing
@Extreming
See here the reason for crossposting
http://www.excelguru.ca/content.php?184
Also refer in your file in which cell you want the result (and also add the desired result).
Whats cross posting?
I just want a answer :S
@extreming
You don't read the link in #14, otherwise you don't have to ask what crossposting is.
I did read it.
I read it just 3 minutes ago.
@Extreming
Please don't post your respond in a private message instead use the forum for that.
Cross post is when you post the same question on several fora.
Please Login or Register to view this content.
According to some forumrules it's not allowed
Doe echt ff kkr normaal man je bnt echt spast
Sorry, I seem to have posted it twice.
Last edited by tasar298; 03-07-2014 at 03:52 PM.
@Extreming, this is the english part of the forum, if you are having a problem with the language, please post in the non-english forum
Also, please upload your workbook here, not all members are able (firewalls and stuff) or willing, to download files from file-hosting sights
@ tasar...posted what twice?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Extreming, please take the time to review our rules. There aren't many, and they are all important. Cross-posting is when you post a question here, and then post the same question on other forums. We allow cross-posting but we require you to provide a link to the other forum if you cross-post.
oeldere has provided a link explaining why we ask you to include a notice in your post if you cross-post (he should have said, "See here the reason for including a link when you crosspost")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks