 |
 | 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 / June 2007Coverting TRUE to 1
I have a table containing TRUE and FALSE values. Essentially I want to count the number of TRUEs, ultimately in a pivot table. Should I convert TRUE to 1 first, (=IF(A1=TRUE,1,0)(??) or is there a way to get a pivot table to cout the number of TRUEs in a category without having to convert first? More elegant solutions will also be considered! Jeff Hi Jeff Whatever your formula is that returns TRUE or FALSE, wrap it inside parentheses with a double unary minus in front. This will coerce the True and False to 1's and 0.'s directly =--( your_Formula)  SignatureRegards Roger Govier >I have a table containing TRUE and FALSE values. Essentially I want to >count the number of TRUEs, ultimately in a pivot table. [quoted text clipped - 6 lines] > > Jeff Hi Roger Now, that one I would never have discovered in a million years! Thanks Jeff > Hi Jeff > [quoted text clipped - 14 lines] >> >> Jeff |
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.