Hi; I have a number of cells which range from cell A1 to G600. The cells all contain numbers which are places randomly and are not in any pattern. The numbers in the cells range from 1 to 50.
I am looking for a function or formulae that counts how many times the number 10 apears in the cell range A1 to G600.
Could anyone help with this.
Take a look to COUNTIF function
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks