i have a series of codes back and forth it seems a bit insane.
but what im wanting is for cell b1 c1 d1 e1 and etc to add together wich i have the following for this to return as my average
it looks like this >>>> =SUM(AVERAGE(B11:H11))/SUM(AVERAGE($B$5:$H$5))
now the only problem im running into is if b1 has a number in it but c1:e1 dose not have numbers
i want them to refer to another cell that dose have number while still viewing as blank
but excluding the blank cells within the final number
im working with %'s
any way its not working to well for me but this is the closest i have gotten to it working
i have cells [_] [_] [_] following this direction>>>> e1-f1-g1
if it looks like this  [_] [_] i need the formula to skip over the blank cells when calculating to give me my total
they can not have 0 in them because 0 is being used other wise
but if the cells are to have #'s like 5 or 10 or 12 ant etc. in them when added like so   [_] they need to be added to the calculation to the total while still avoiding adding the blank cell to the total
it needs to only calculate the total within the cells that have numbers in them so its not adding the blank cells as part of the total .... its kina complicated i guess
reason for the diff formulas is just my testing them out
i am wanting to add to total score and divide it by total maximum possible score
but if there is a blank cell i need to read it as if it did not exist
if there is a blank cell i want it to read the possible score in the total
to provide a current grade...
for example assignment one has been done and now currently working on assignment 2
lets say assignment 1 has a possible points of 30 and i have received 30 points for it my grade should read as 100% A even though assignment 2,3,4,5..etc have no points entered in.
really simply the question asked is what is my grade so far with the assignments we have done.
i guess i need the cells that have nothing entered to = the possible points without showing in the individual cells. and still get a correct % and grade letter..