 |
 | 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 / Worksheet Functions / August 2006tally of nonblank cells
I have tried to use the =COUNTA( ) function, but when I select the range of cells to tally, I don't get a number of cells, I get only the function The cell with the formula in is probably formatted as Text. Use Format | Cells | Number (tab) to confirm this, and select General or Number with 0 dp. To get Excel to react to this change, double-click the cell (as if to edit it) then click elsewhere. Hope this helps. Pete > I have tried to use the =COUNTA( ) function, but when I select the range of > cells to tally, I don't get a number of cells, I get only the function It worked! Thanks so much! > I have tried to use the =COUNTA( ) function, but when I select the range of > cells to tally, I don't get a number of cells, I get only the function You're welcome. Pete > It worked! Thanks so much! > > > I have tried to use the =COUNTA( ) function, but when I select the range of > > cells to tally, I don't get a number of cells, I get only the function |
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.