On a course advising layout each course the student has taken is laid out with some characteristics about each course. One of which is whether or a transferring course is a 4 year institution (SR) or Community College (CC).

There are roughly 35 unique fields that capture this info. The user decides for each course whether that course was offered at either a SR or CC by way of a drop-down.

I want to be able to count all of the SRs and CCs but am not sure how to go about that since they span a bunch of fields.

Ex: SRCCElectives1, SRCCElectives2, SRCCElectives3, etc. (there are 35 of these)

Ideally, this calculation would display in Browse Mode but I know how finicky FileMaker is about that.

This report would allow us to determine how many hours came from the 4-year schools and how many from Comm. Colleges without having to count it out by hand.

Any ideas?

You may want to think about going relational here. Anytime you start having multiple fields with the same name, Ex: SRCCElectives1, SRCCElectives2, SRCCElectives3, etc. (there are 35 of these), then its a good time to rethink your structure.

Ok, I'm going to show my newbie-ness here but how would you go about making this a relational situation?

Well you could start with a student table and a choices table. You could also have a courses table should you want to store all the courses instead of in a value list.

You can use a portal to display the choices for each student.