Help with counting with conditions and merged cells

**Rebs** · 11-12-2010, 12:44 PM

Hey Everybody!

I'm making a spreadsheet with requirements for med school entrance and I'm having trouble writing a formula.

Take a look at the attached excel. I'm trying to write a formula that would count if a med school requires a subject and then if it requires 1 semester of it, 2 semesters, or more than 2. Any help would be awesome!

Thanks

**scottylad2** · 11-12-2010, 12:51 PM

Coulp you show the answer to a couple of cells of data and indicate how one would arrive at the count? not entirely clear from your sample

**Rebs** · 11-12-2010, 02:04 PM

Yeah Absolutely! So for Example, in Medical school A General Chemistry is required (As indicated by the dot in the required row) and 2 semesters are required (as indicated by the number 2 in the semesters row). So I would want the formula to count that as 1 and then count the total number of school that have general chemistry required for 2 semesters. I attached what the actual values would be for each column with actual values in another upload.

If that still isn't clear let me know. I'm having troubles articulating exactly what I want.

Thanks so much!