Creating a Weighted Average Grade Book in Excel

So I was searching all around and had no luck finding one that would do what I wanted. Went ahead and fired up Microsoft Excel, and here is a version I made with the weighted categories in rows and the assignments in columns. Should be fairly simple to duplicate using the example below and formulas provided. Narrowed the amount of columns to fit the post. If you have any questions I will certainly try and help out.

	A	B	C	D	E	F	G	H	I	J	K
1	Calculated Weighted GradeBook
2	Category	Weight	ASSG #1	ASSG #2	ASSG #3	ASSG #4	ASSG #5	ASSG #6	ASSG #7	ASSG #8	average
3	Category #1	20%		100%	0%						50%
4	Category #2	22%				93%					93%
5	Category #3	8%					100%	97%			99%
6	Category #4	45%									-
7	Category #5	5%									-
8										Grade	76.68%

Spreadsheet Formulas

Cell Formula K3 =IF(COUNT(C3:J3),AVERAGE(C3:J3),"-") K4 =IF(COUNT(C4:J4),AVERAGE(C4:J4),"-") K5 =IF(COUNT(C5:J5),AVERAGE(C5:J5),"-") K6 =IF(COUNT(C6:J6),AVERAGE(C6:J6),"-") K7 =IF(COUNT(C7:J7),AVERAGE(C7:J7),"-") K8 {=SUMPRODUCT(B3:B7,K3:K7)/SUM(IF(K3:K7<>"-",B3:B7))}

Formula Array: For K8 Produce enclosing { } by entering formula with CTRL+SHIFT+ENTER!

6:35 PM