Sum 3 non-adjacent cells, some are blank

[chjourdain]

Hi,
I am trying to sum 3 non-adjacent cells. Some cells are blank, not always in the same row / column, and all are the result of vlookups. I tried: E = I+M+Q, but the result is #value!

-In column E (respectively F, G, H) that's where I want the result of the sum
-In column I (respectively, J, K, L), depending on the row, some cells are blank and some cells contain a number. That's the first term of my sum.
-In column M (respectively N, O, P), I have also blank and non-blank cells, depending on the row. This is the second term of my sum.
-In column Q (respectively R, S, T), also blank or non-blank cells. This is the third term of my sum.

I will need to extend this formula to F=J+N+R, G=K+O+S, H=L+P+T, and probably also a sum with 4 terms where E=I+M+Q+U etc.

Thank you for any help!

 

[Marcelo Branco]

Not sure if I understand what you need

Try

Ex
=SUM(Ix,Mx,Qx)

where x is the row number

M.

 

[chjourdain]

thanks, I thought I had tried that also but apparently not