Divided sums of 2 columns with denominator changing based on blank values in a column

Hello,

I am trying to create a sheet on docs.google.com that takes the sum of 1 row divided by the sum of another row removing numbers from the denominator if fields are left blank. Hard for me to explain so here is an example:

Counter	Column 2	Column 3
2	2	blank value
2	blank value	1
2	2	2
6	4	3

Leaving a blank value in column 2 makes it read 4/6 giving me 66%, Column 3 giving me 50%.

What I would like it to do is if there is a blank value in any column remove column one from the denominator.

Upon completion the total output percentage for column 2 should be 100%, and column 3 should be 75%.

I thank you for any help you can provide.

Assuming the data is A2:C4, put this formula in B5 and then copy to the right:

=SUM(B$2:B$4) / SUMIF(B$2:B$4, "<>", $A$2:$A$4)

I've marked this thread as SOLVED for you.
Next time, select Thread Tools from the links above to mark a thread as SOLVED. Thanks.