I have a spreadsheet of student data and I want to analyse data in four
columns in particular. The columns identify school terms and contain numeric
values which identify a school subject code. (Codes run from 1-15).

I need to count each subject a student studied over the four terms and I can
do this easily when the codes refer to single subjects. (I had help from
T.Valko and Teethless Mama - thank you both!)

However, when I went back to double check the data I realised that there was
a complication.

Codes 1 to 4 identify four different subjects, while codes 5 to 15 represent
various combinations of those four subjects. e.g. Code 5 means the student
studied subject codes 1 and 4; code 7 equals subjects 3 and 4, and 6 equals
subjects 1, 2 and 4, and so on for the rest of the codes.

The data looks something like this in the spreadsheet:

Term 1-----Term 2-----Term 3-----Term 4
1 ------------ 1 ---------- 4 ----------10
0 ------------ 1 -----------1 ---------- 1
10----------- 2 -----------1 -----------6
4 ------------ 0 -----------7 -----------1

Is there a way to count each subject only once? And can it be done in Excel
2003?

Thank you.

LisaM


(This was my original query on funtions -
http://www.microsoft.com/office/comm...=en-us&m=1&p=1)