SUM

[Alexandru Dan Mitache]

Hello...
I need the simplest formula in cell H2, in wich to add all the results (quotients) of the divisions of A2/B2, C2/D2 and E2/F2, but only for the not empty B2, D2 or F2 cells.
Thank you!

 

[saboh12617]

Hello,
You can use the formula below :

=IFERROR(A2/B2,0)+IFERROR(C2/D2,0)+IFERROR(E2/F2,0)

If in reality you have a very long array, you might use the formula below :

=LET(vals,A2:F2,
dividends,FILTER(vals,MOD(COLUMN(vals),2)=1),
divisors,FILTER(vals,MOD(COLUMN(vals),2)=0),
SUM(IFERROR(dividends/divisors,0)))

 

[Alexandru Dan Mitache]

Thank you, Saboh12617!
It works!
Best regards!

 

[saboh12617]

Glad to help, have a good day.