Sumif Fucntion

[bcuinohio]

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

[dominicb]

Good evening bcuinohio

Yes you can but it's a bind and requires the use of arrays. If you're not familiar with those try using the Conditional Sum add-in. It will build the array formula for you.

HTH

DominicB

[Peo Sjoblom]

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