Coverting TRUE to 1

  • Thread starter Thread starter Jeff Granger
  • Start date Start date
J

Jeff Granger

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)
 
Hi Roger

Now, that one I would never have discovered in a million years!

Thanks

Jeff
 
Back
Top