N
N Lennox
I have the following formula
=((A1+B1+C1+D1+E1+S1)+(F1+G1+H1+I1+J1+T1)/2)/9
and want to write it in a way that it will ignore errors,
however, the catch is that if A is an error than the
forumla must ignore F as well (same for B and G, C and H,
D and I, S and T).
I've been trying formulas with stuctures similar to
=SUM(IF(NOT(ISERROR((A2,B2,C2,D2,E2))),(A2,B2,C2,D2,E2)))
but not having much luck.
Thank you very much.
=((A1+B1+C1+D1+E1+S1)+(F1+G1+H1+I1+J1+T1)/2)/9
and want to write it in a way that it will ignore errors,
however, the catch is that if A is an error than the
forumla must ignore F as well (same for B and G, C and H,
D and I, S and T).
I've been trying formulas with stuctures similar to
=SUM(IF(NOT(ISERROR((A2,B2,C2,D2,E2))),(A2,B2,C2,D2,E2)))
but not having much luck.
Thank you very much.