Sumif Fucntion
 

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

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


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=375483