I have a string of 15 cell like this: 3 2 3 4 3 3 2 2 4 4 4 0 3 3 2 (Total) 42
I am looking for a formula that tell me that 4 appears in the selected cells 4 times, that 3 appears 6 times and that 2 appears 4 times (I don't care about the zero's)
For all you guys (and gals) this is probably child's play, but I seriously missed all of my math classes many, many years ago ...
LOL
Thanks
Peter
Last edited by Staywme; 08-19-2017 at 05:47 PM.
Hate to be a bother. I tried again.
Best
Peter
It is not great but it will do.
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.
You need to read up on the COUNTIF function.
Ali
Since I am totally out of my league here; what would be a better title. I am trying to conform but could use some insight. Thanks for your expert advise.
Peter
"How to count the frequency of numbers in a range of cells".
You're awesome. Thanks.
Will do with any future questions.
Appreciate your kind replies and help
Peter
So to find out how many 6s there are in your range, assuming it's from A1 to A15, this:
=COUNTIF(A1:A15,6)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks