Hi
SUMPRODUCT will allow multi-criteria whereas SUMIF only allows one criteria.
Now if I understand rightly, you have one criteria and several columns to
add.
In which case you may add several SUMPRODUCT together.

HTH
Cordially
Pascal

"sumproduct if" <sumproduct a écrit dans le
message de news: ...
i need a "sumproductif" function:, a combination of sumif and sumproduct

e.g. i need to sumproduct values in columns A and B if a condition in
column
C holds

does anyone know of anything that would do this??