Need help with a COUNTIF function to identify if the end of a number ends with a specific number.... e.g.
Looking to count the number of times the numbers below end with a 9. Tried the COUNTIF(Range,"*9") and a few other variations, but I cannot seem to get it to work.
12.55
12.65
12.75
12.89
12.59
11.39
10.58
13.57
14.59
Any suggestions?
Thanks
Last edited by NBVC; 09-15-2011 at 03:56 PM.
How about =SUM(INDEX(--(RIGHT(Range,1)="9"),0))
Perhaps something like:
=SUMPRODUCT(--(ROUND(A1:A9,1)-0.01=A1:A9))
Last edited by NBVC; 09-15-2011 at 11:44 AM.
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
Somehow, Andrew-R's post got separated into it's own threadI re-merged it back.
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
Your post does not comply with Rule 5 of our Forum RULES. We have Seven question forums: Miscellaneous, General, Programming, Worksheet Functions, Charting, Excel 2007 Help and New Users. Please choose the appropriate forum, and post your question in ONLY one forum.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Maybe I just wanted to ask the world what they thought about my formula.Originally Posted by NBVC
Somehow, Andrew-R's post got separated into it's own thread
My pert, **** little formula.
That worked. Thanks very much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks