Morning,
I am struggling to get a formula that will countif a value of 2 or higher is in the column A2:A111
Any help would be appreciated.
Many thanks
Morning,
I am struggling to get a formula that will countif a value of 2 or higher is in the column A2:A111
Any help would be appreciated.
Many thanks
Last edited by Cmorgan; 09-16-2014 at 05:21 AM.
try this
=COUNTIF(A2:A111,">="&2)
Punnam
Do you mean?
Formula:Please Login or Register to view this content.
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.
i'm about to type the same solution.
You can use sumproduct too (other than countif)
Please Login or Register to view this content.
-If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".
-Always upload a workbook before start your question
To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
+++ If my answer(s) helped you, please add me reputation by click on * +++
Many thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks