G
Guest
Dear all,
I set a SUMIF Function in a cell as :
=SUMIF(B2:B222, "Jack", C2:N222).
However, the return to the cell is 0. I think this SUMIF Function is not
working because the figures in cells C2:N222 are created by another worksheet
function and not by actual numbers. Please advise how to remedy this problem
Thanks.
I set a SUMIF Function in a cell as :
=SUMIF(B2:B222, "Jack", C2:N222).
However, the return to the cell is 0. I think this SUMIF Function is not
working because the figures in cells C2:N222 are created by another worksheet
function and not by actual numbers. Please advise how to remedy this problem
Thanks.