Excel Skipping a cell when calculating a tota [Solved/Closed]

Report
Posts
16
Registration date
Friday April 23, 2010
Status
Member
Last seen
April 27, 2010
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
763

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!