countif multiple criteria.

**mrdisposal** · 10-09-2008, 03:06 PM

I'm trying to count multiple criteria from a second page in a work book, all the formulas i've looked up and tried do not seem to work... here's the formulas i've tried..

DKOBULAR is the name of the 2nd page...
D is the column used for the different resolves.

=COUNTIF(DKOBULAR!D:D="resolveA")+COUNTIF(DKOBULAR!D:D="resolveB")+COUNTIF(DKOBULAR!D:D="resolveC")+ COUNTIF(DKOBULAR!D:D="resolveD")

=COUNT(IF(DKOBULAR!D:D="resolveA",IF(DKOBULAR!D:D="resolveB",IF(DKOBULAR!D:D="resolveC",IF(DKOBULAR! D:D="resolveD")))))

What am I doing wrong?

**mrdisposal** · 10-09-2008, 03:23 PM

looking through this site, it appears i might need to use the
=SUMPRODUCT function, but i'm having difficulty using the examples i've found to write the formula for what i need...

**daddylonglegs** · 10-09-2008, 03:27 PM

You need a comma instead of = inside COUNTIF, i.e.

=COUNTIF(DKOBULAR!D:D,"resolveA")+COUNTIF(DKOBULAR!D:D,"resolveB")+COUNTIF(DKOBULAR!D:D,"resolveC")+ COUNTIF(DKOBULAR!D:D,"resolveD")

although you could shorten to

=SUM(COUNTIF(DKOBULAR!D:D,{"resolveA","resolveB","resolveC","resolveD"}))

or, if you need to count all resolves you might be able to use a "wildcard", i.e.

=COUNTIF(DKOBULAR!D:D,"resolve?")

**mrdisposal** · 10-09-2008, 04:10 PM

odd... the first formula you gave me worked, but the truncated version didn't count all the data... regardless of it being longer the first formula worked though, so thank you!