Ignore Blank Cells

[djaldente]

Hi,

Can someone help me with this formula please.. If any of the I cells (I18, I19, I20) are blank I need them not to be counted.

=(C13/(C13/I18+C13/I19+C13/I20)*K6*K18)+(C13/(C13/I18+C13/I19+C13/I20)*K6*K19)+(C13/(C13/I18+C13/I19+C13/I20)*K6*K20)

Cheers

 

[inactiveuserps07]

Happy to hear it, Charlie. Thanks for confirming.

 

[pgc01]

Charlie

Another option:

=HARMEAN(I18:I20)/COUNT(I18:I20)*K6*(K18+K19+K20)


Did you already confirm that C13 is doing nothing there?
Try the following: with a formula you trust change the value of C13 to several different values and see that the result does not change.