Each record I have has 7 different serial number fields. Some records just
have 1 serial number, while others might have multiple. My fields are named
SN1, SN2, SN3, etc, but regardless of which field the # is in, it is still
essentially the same. I am making a pivot table where I want to count how
many total serial numbers fall into each category of record type. The only
things I have tried so far give me the format shown below, but I need a
single count instead of seperate counts. Is this possible?

Category Data Total
Category A Count of SN1 3
Count of SN2 8
Count of SN3 2
Count of SN4 5
Count of SN5 6
Count of SN6 2
Count of SN7 17
Category B Count of SN1 6
Count of SN2 9
Count of SN3 5
Count of SN4 3
Count of SN5 9
Count of SN6 16
Count of SN7 5
Category C Count of SN1 9
Count of SN2 14
Count of SN3 7
Count of SN4 3
Count of SN5 13
Count of SN6 6
Count of SN7 3