Excel has a DSUM function as well that can be used although the criteria is a
bit arcaic, you can not use SUMIF but you can use SUMPRODUCT

=SUMPRODUCT(--(A2:A300="x"),--(B2:B300="Y"))

is and example of AND

Regards,

Peo Sjoblom

"bcuinohio" wrote:

Is it possible to use the sumif function with multiple criteria. (AND, OR)

I am trying to convert old lotus files that used the dsum function to excel