LinkBack URL
About LinkBacks
Hi, i put:=COUNT.IF(A3:A49;"*0")
why doesn't work? what I'm doing wrong?
I want find numbers ending zero, but i canīt, can you help me? thanks
Hi, i put:=COUNT.IF(A3:A49;"*0")
why doesn't work? what I'm doing wrong?
I want find numbers ending zero, but i canīt, can you help me? thanks
Hi,
Use this..press ctrl+shift+enter
Formula:
Please Login or Register to view this content.
If your question is resolved, mark it SOLVED using the thread tools. Click on the star if you think some-1 helped you.
Last edited by LokeshKumar; 04-27-2015 at 07:04 AM.
Lokesh Kumar
Stay Hungry.. Stay Foolish..
_________________________________________________________
Please Click STAR to Add Reputation if my/someone's answer helped!
If your question is resolved, mark it SOLVED using the thread tools. Click on the star if you think some-1 helped you.
or
=SUMPRODUCT((RIGHT(B4:B9,1)="0")*1)
or
=SUMPRODUCT(--(RIGHT(B4:B9,1)="0"))
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
SUM(IF doesn't work, is it SUM.IF or COUNT.IF or SUMPRODUCT?
SUM(IF etc does work. Are you sure that you entered it as an array formula (CTRL SHIFT ENTER) and not as a regular formula (ENTER)?
Also, did you just want to count the number of values that end in zero, or what?
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Hi,Originally Posted by virtualman
Are you sure you have followed the instruction....
CSE you have to press ctrl+shift+enter while entering this formula.....Formula:Please Login or Register to view this content.
no need........Formula:Please Login or Register to view this content.
no need........Formula:Please Login or Register to view this content.
If your question is resolved, mark it SOLVED using the thread tools. Click on the star if you think some-1 helped you.
This will not count 0s that are added through custom formatting. For example, the cell value is 1.1 but you format it to display as 1.10.
=SUMPRODUCT(--(RIGHT(B4:B9)="0"))
Last edited by Tony Valko; 04-27-2015 at 09:36 AM.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
I have a similar problem, but I have a numeric set of fields I want to count that contain a number string that represents phone numbers. I want to count how many of them are toll free numbers and how many are not.
a sequence will look something like this: 91800XXXXXXX; 91866XXXXXXX; 91877XXXXXXX; 91888XXXXXXX or they may be 91XXXXXXXXXX where the x's represent long distance calls. I have looked at COUNTIF(S) and have found that won't work. It does seem like a =SUM or =SUMPRODUCT might work but I can't seem to get it down. In some of the examples above like: =SUM(IF(RIGHT($A$3:$A$49,1)="0",1)) I take it the part [ "0",1) ] the one is the number of digits in the field, right? I'm beginning to think this is either impossible or complicated and I'm leaning toward complicated. I have to believe there is a way to do what I'm trying to do. Thanks guys.
use this formula: (if you want to sum all number ending with 0)
=SUMPRODUCT(--(MOD($A$3:$A$49,10)=0)*($A$3:$A$49))
Last edited by salim ali; 04-30-2015 at 03:41 PM.
look at this file:
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks