Good morning friends,
In my file I want to count the entries in range b6:y6 in cell d4. I require a formula to count the entries range b6:y6 in cell d4.
Now in my file there are 3 entries in the range b6:y6 which comes from the range b10:y10 as a result of formula in b6:y6, =b10 respectively.
Please suggest me a formula to count entries. I used countif formula but there was a error incorrect formula.
Thanking you in anticipation.
Mukesh
Did you try this:
=COUNTIF(B6:Y6,"<>0")
Hope this helps.
Pete
Im not sure I understand what you want, but try this...
=COUNTIF(B6:Y6,"<>0")
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
lol is there an echo in here, Pete?
two in a row for both.
if entries will be all text ( i mean count only the text entries) you can also use something like this
=COUNTA(B6:Y6)-COUNT((B6:Y6))
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
=countif(b6:y6,"*")
Hello Pete_UK,
Thank you. It's working fine.
Mukesh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks