how to calculate the total of survey record to match two fields????

bbsin since you mention "a huge list", I would consider using Power Query (PQ) and a pivot table.

First unpivot the survey results in PQ and load the data to the data model and then re-pivot all, counting the number of occurrences by answer.

I've created a mock-up based on what you showed in your picture. Is that something you could work with? See attached workbook.