excel pivot table - multiple columns

I'm trying to create a pivot table in Excel using the following data:

The end result I'm trying to come up with (using the pivot) is a summary like this:

However I can't figure out how to get Excel to count / add / consider all columns. I can create a pivot for each individual field/column, but can't figure out how to compile the data together.

How do I put two columns side by side in a pivot table?

Add an Additional Row or Column Field Click any cell in the PivotTable. The PivotTable Fields pane appears. You can also turn on the PivotTable Fields pane by clicking the Field List button on the Analyze tab. Click and drag a field to the Rows or Columns area.

How many columns can a pivot table handle?

The following limitations apply to pivot tables: You can create pivot tables with up to 500,000 records. You can add up to 20 fields as rows and 20 fields as columns.

Forgive the mac excel in the picture but here is how you can set up a pivot table.

Note though that the row labels will reflect only categories that are in the column you put in the row section

enter image description here