Countif and Sumif multi criteria

[dgrimm]

I am trying to do a countif and sumif while using multiple criteria. I do not want to create an id for each of them.

what I would like is something like this

countif(colA: colB = 1 and colf = "S" and colh = 10 and colj = "D")

then the same thing for sumif.

Is it possible or not....

Thanks in advance.

Dave

 

[VoG]

Take a look at SUMPRODUCT http://www.xldynamic.com/source/xld.SUMPRODUCT.html