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.

## Best Answer

If I understand it, then you need this:

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