Hi! Following from previous problem that has been solved, I tried to apply the following solutions that work fine on the range M2:P2 but don't work when I include I2 in the range to be summed:
{=SUM(IF(ISNUMBER(M2:P2,I2),M2:P2,I2),1)}
=SUMIF(M2:P2,I2,"<>#N/A")
What should I do to get around this problem?
{=SUM(IF(ISNUMBER(M2:P2,I2),M2:P2,I2),1)}
=SUMIF(M2:P2,I2,"<>#N/A")
What should I do to get around this problem?