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)

--
Regards

Roger Govier


"Jeff Granger" <(E-Mail Removed)> wrote in message
news:Y-(E-Mail Removed)...
>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 Roger

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

Thanks

Jeff


"Roger Govier" <(E-Mail Removed)> wrote in message
news:%23fApz%(E-Mail Removed)...
> 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)
>
> --
> Regards
>
> Roger Govier
>
>
> "Jeff Granger" <(E-Mail Removed)> wrote in message
> news:Y-(E-Mail Removed)...
>>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
>>
>
>