Hi Tech,
I've been pulling my hair out over this one.
The range F3:F7 holds numbers. Cell G9 holds the sum of F3:F7. I want G9 to sum only the values in that range where the corresponding cells in columns I, J and K are blank.
In other words, if F3=9, and either I3, J3 or K3 are not blank, then G9 does not include F3 in its sum.
F3=9 | I3=<> | J3=<> | K3=TRUE
F4=8 | I4=<> | J4=<> | K4=<>
F5=7 | I5=<> | J5=<> | K5=<>
F6=4 | I6=<> | J6=<> | K6=<>
F7=3 | I7=<> | J7=<> | K7=TRUE
G9=19 (or G9=F4+F5+F6)
I haven't been able to make nested IFs, SUMs or SUMIFs work for me. Obviously, I'm not going about it in the right way. I thank you most ardently for your kind attention.
I've been pulling my hair out over this one.
The range F3:F7 holds numbers. Cell G9 holds the sum of F3:F7. I want G9 to sum only the values in that range where the corresponding cells in columns I, J and K are blank.
In other words, if F3=9, and either I3, J3 or K3 are not blank, then G9 does not include F3 in its sum.
F3=9 | I3=<> | J3=<> | K3=TRUE
F4=8 | I4=<> | J4=<> | K4=<>
F5=7 | I5=<> | J5=<> | K5=<>
F6=4 | I6=<> | J6=<> | K6=<>
F7=3 | I7=<> | J7=<> | K7=TRUE
G9=19 (or G9=F4+F5+F6)
I haven't been able to make nested IFs, SUMs or SUMIFs work for me. Obviously, I'm not going about it in the right way. I thank you most ardently for your kind attention.