I am working with counting student data based on term status, sex, college,
degree, campus and major. I have 9 columns of data (5519 records). I have
been using SUMPRODUCT to get a count of data in each column based on the
criteria I specify. Basically all columns have the same general data as noted
below:

TmSt Sx Col Lv Deg Cls Cm Prg Maj
FT M GN GN PHD G2 N BEN2_PHD BEN2
FT S GN GN PHD G2 N NEU2_PHD NEU2

My problem arises because the column labeled "Maj" has differing data based
on the program a student is pursuing. Is there a way this can be accomplished?

Thanking you in advance.