# Excel Skipping a cell when calculating a tota

Solved/Closed
starhawk85 Posts 16 Registration date Friday April 23, 2010 Status Member Last seen April 27, 2010 - Apr 23, 2010 at 06:58 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 23, 2010 at 07:32 PM
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

=SUM(IF(B9="",B9,\$B\$5),IF(C9="",C9,\$C\$5),IF(D9="",D9,\$D\$5),IF(E9="",E9,\$E\$5),IF(F9="",F9,\$F\$5),IF(G9="",G9,\$G\$5),IF(H9="",H9,\$H\$5)/SUM(\$B\$5:\$H\$5))

but the final % is way off.. and im not sure if it is truely not counting the blank cells

ANY HELP WOULD BE GREATLY APPRECIATED

Related:

## 1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Apr 23, 2010 at 07:32 PM