How to make a pivot table that counts from multiple columns?

I have a workday schedule in which I will count how many times I do each activity across the week. Here's an example:

The pivot table only allows me to count from MWF or TT but not from both without doing some weird nesting. For example, I want to see the following:

Labels            Count

Sleep              8
H: Lift weights    2
Commute to office  2
...

I tried MS Excel and Google Sheets and couldn't get it to work. Any ideas?

Solution 1:

That's just how pivot tables work. The aggregation only works on one column.

But you can easily do the count with a CountIf(). Build a table of unique values, like in column E in the screenshot and then plug them into CountIf() like below.

=COUNTIF(B:C,E2)