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