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 4479 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

1 reply

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