Sumif Fucntion

G

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMIF with criteria "<>" & "=" 4
quick question on sumif 3
No difference between SUM and SUBTOTAL (9) 1
Can function be applied to range in sumif prior to criteria check? 4
SUMIF on a Calculated Field 3
SUMIF ERROR 3
Multiple SUMIF criteria 1
subtotal with sumif nested 1

Top