I have a table of True and Falses that I want to count in a pivot table. But I would like to count how many True values per employee by assigning a 1 to True and a 0 to False. How do I go about that?

Right now Excel is just counting whatever is in the columns as 1 when I insert a pivot table. I'd like to show how many True values there are.

CodePudding user response：

Do you need to use a pivot table?

An easy option is to add another column to your data with this formula:

=countif(<range-of-column>,TRUE())

So for the first row, it might look something like this:

=countif(B2:B4,TRUE())

This is basically going through the row and counting the number of TRUEs that exist in that row.