# Credit Hours Earned, Required Classes Completed

#### whitaker

##### New Member
I need two formulas to reslove the following information for hundreds of students.
1) How many credit hours has a student earned by completing "Required" classes? 2) How many hours has a student earned by completing "Elective" classes?

1) Range: (G3:AF3) contains a list of classes that are required by various students, but not all students. Range: (G4:AF4) contains the hours earned by completing the class.
Beginning with Row 4, I have placed an "x" in all the cells that are not required by the student and left the ones that are required blank. When I put a "date" in the blank cell, i want the formula to add the credit hours for that class to thestudents total in column D. Each time a class is completed, the credit hours will be added to the total.
2) Range: (AH3:BH3) contains teh list of "Elective" classes and (AH4:BH4) the corresponding credit hours earned when completed. I want to do the same thing here except all the cells are blank until a date completed is entered. The total for "elective" classes will go in column E.

Hope that make sense. Thanks for the help.

### Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
Excel Workbook
2Req'dElective
3Class Name:Req'dElectiveClass AClass BElective AElective B
4Hours:TotalTotal5324
5Andy Alfa32X1/1/20092/16/2009
6Bernie Bravo34X1/26/20091/12/2009
7Christine Charlie562/5/20094/1/20091/18/2009
8Danny Delta00X
9Ernie Echo06XX1/22/20093/6/2009
10Fanny Foxtrot522/13/2009X3/18/2009
Sheet1

Last edited:
Simply amazing! Wish I understood more about formulas. Thank you so much for the reply.

Read up on SUMPRODUCT() here. If you want to understand more, you need to put in the effort to learn! Most of us (Aladin excluded) did not pop out of the womb with Excel installed in our brains.

Replies
2
Views
389
Replies
6
Views
1K
Replies
3
Views
1K
Replies
17
Views
1K
Replies
6
Views
1K

1,196,501
Messages
6,015,563
Members
441,901
Latest member
joshtfin

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back