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.

Hi,

I found the following from Excel Help.

"Sum_range does not have to be the same size and shape as range. The actual cells that are added are determined by using the top, left cell in sum_range as the beginning cell, and then including cells that correspond in size and shape to range."

Do you have all 0's for column C? Since the "range" is only one column which is "B," the corresponding "sum_range" will also be one column i.e. "C."

I did a little test using one column for range and two columns for sum_range. Only ONE column (the first column) from sum_range is added up. I created the data from scratch on one sheet.

Let's see what the experts will say.

Epinn

"Freshman" wrote in message ...
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.

What is the other formula?

Biff

"Freshman" wrote in message
...
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.