 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / March 2008Simple countif syntax request
Hi, I used to use Excel a lot but haven't for a few years. What is the syntax for using a countif function these days? "=countif(a1:a10,>b2)" used to do the trick I have tried using help but for some reason "=COUNTIF(B29:B40,">B23")" is not giving me the correct result, ie if I put 6.5 into cell b23 it is returning 0 not the number of cells in the range B29:B40 which are greater than 6.5 which is incredibly frustrating! Thanks, Will If you have a cell reference as part of the condition, you have to use the function like this: =COUNTIF(B29:B40,">"&B23) Hope this helps. Pete > Hi, > [quoted text clipped - 13 lines] > > Will
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.