Posted: 4/2/2012 10:19:03 AM EDT
|
I am trying to create an excell sheet formula to track grades as I get them. So I have a column of max points and then I have a column of earned points. Right now I have a sumif formula that only does the math if an assignment has an earned points value, =SUM(B2:B14)/(SUMIFS(C2:C14, B2:B14, ">0")) The B column contains my earned points and the C column contains max points.
The problem with this formula is it doesn't account for having recieved a zero on an assignment. Is there a way to modify the formula so it ignores a blank cell in the B column yet will account for an earned score of 0? Second question. How can I set up a formula to give me a max possible score in the class? I had one earlier but the formula needed to be updated every time I had a new grade to put in the sheet. What it would be is sum of max points minus the difference between the assingment max points and the assingment earned points. I have no clue how to type that out into a formula that doesn't have to be updated every time a new grade is entered. Edit:=SUM(B2:B8)/(SUMIFS(C2:C8, B2:B8, ">=0")) I changed the greater to 0 to an greater than or equal to zero, so no I can enter a grade in as a 0 and it will automatically update my grade. I think way of thinking about my second question was off. What I need it to do is add up the earned points column, assume any blank spots would be the assignment max points and then take that sum and divide it by the sum of max points. That and I am going to sleep, too much thinking for one day. |