In the following image, what I'm trying to do is to find a formula that will divide values on column C by values on column L, ONLY IF:

  • Value on column D = "L", and
  • Value on column J = "Right", and
  • Value on column K = "C", and
  • Value on column L <> 0 (isn't empty)

And then return the sum of those divisions.

So, for example, in this image, it would first: - Divide C7 by L7, then - Divide C12 by L12, then - Divide C15 by L15, and finally - Return the sum of the results of those divisions.

I have made multiple attempts with arrayformulas and sum(if) conjugates, to no sucess.

Thanks in advance.

Test sheet


1 Answer 1


If I understand it, then you need this:

             J7; "Right"; 
             K7; "C"; 
             L7; "<>"); C7/L7; ; )

and then drag it down where it's needed...

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.