Adding similar frequencies of different variables

[Rakhi Vash]

Hi all, I am trying to add the similar frequencies of different variables to get the total of 1s, 2s and 3s. For example : I have ED admissions due to heart attack (ED_heartattack_freq) = 1, 2, 3, ...10 times, then ED admissions due to lung cancer (ED_lungcancer_freq)= 2, 4, 6 times, ED admissions due to hip fracture (ED_hipfracture_freq)= 3, 7, 8 , 10 and so on for about 10 different conditions. I want to calculate how many patients had 1 ED admission for any condition, how many patients had total 2 ED admissions and so on. I tried using rowtotal but it did not work because it adds 1 ED admissions of heart attack with 2 ED admissions of lung cancer and 3 ED admissions of hip fracture. Any help with is much appreciated. Thanks in advance.