Sumif Fucntion

[Guest]

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