Sumif Fucntion

B

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
 
D

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
 
Top