Hi,
I want to count the number of cells that have a value that is above the average of all of them. Ive tried the COUNTIF formula but no luck. Any assistance would be appreciated. I reckon this will be an easy one for someone! Thanks. Sample attached.
You need to do countif, but with your avarage formula as the criteria.
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
Sorry, I dont understand. So in cell J3, should I have: =COUNTIF(C3:H3,">A3") ? That doesnt work for me. Thanks
=COUNTIF(C3:H3,">A3") is text not a cell reference
it should be
=COUNTIF(C3:H3,">"&A3)
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Try this solution with one formula
=COUNTIF(C3:H3,">="&INT(AVERAGEIF(C3:H3,">0")))
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks