Both functions work just fine with the comparison column on one seet and
the sum column on another. Unless you post your formulas, there is
little chance that we can guess what you did wrong.

SUMPRODUCT is not able to address an entire column (as in A:A), but
SUMIF can.

Jerry

Fuad wrote:

Hi All,

I need to sum several columns in defferent sheet into another one with a
criteria.

Like column A in both sheets are the same data, but in Sheet 1, I have
several columns that I need to sum up in Sheet 2 on the basis of data stored
in column A in both sheets. I am trying SUMIF(), SUMPRODUCT(), but no use, so
far...

Can anyone help...?

Regards,

Fuad