Use SUMPRODUCT.

See countless examples in this newsgroup.
--
David Biddulph

"Lorenzo" wrote in message
...
I would like to sum a column only if meets the criteria of one and another
column.
what formula should i be using? i was using sumif but this is for the
criteria of one column.