COUNTIF INDIRECT Multiple Criteria

[Jtucker10278]

Need help with the formula

=COUNTIF(C12:H23,1)+COUNTIF(C12:H23,2)

Where C13:H23 = Named Range Week_1

I already know indirect has its drawbacks im just doing some quick and dirty analysis.

Thanks for the help

 

[Special-K99]

The range in your formula is C12:H13 (twice) but your description states C13:H23. So which is correct?

There's no INDIRECT() mentioned in your formula, that's a normal range.

And I can't see you've stated a problem either ?

"Need help with a formula"
What does that mean?

 

[Jtucker10278]

Oops that's embarrassing (trying to do to may things at once)

so im trying to make this formula

=COUNTIF(C12:H23,1)+COUNTIF(C12:H23,2) C12:H23 = Named range Week_1

work somthing like

=COUNTIF((INDIRECT(A1)),1)+COUNTIF((INDRECT(A1)),2) A1 = Week_1


big picture, Im trying to count all the values = to 1,2 in named range Week_1 (and in Week_2, Week_3, ect)

Thanks Again

 

[Jonmo1]

That will work so long as the named range is NOT dynamic (no use of offset, counta etc..) Only a direct reference like =$C$12:$H$23
Although you misspelled INDRECT the 2nd time...

But you're a bit overkill with the parens..
=COUNTIF((INDIRECT(A1)),1)+COUNTIF((INDRECT(A1)),2)
Can just be
=COUNTIF(INDIRECT(A1),1)+COUNTIF(INDIRECT(A1),2)

 

[Jonmo1]

On a side note, here's a shortcut to the multiple criteria..

=COUNTIF(C12:H23,1)+COUNTIF(C12:H23,2)

Try

=SUM(COUNTIF(C12:H23,{1,2}))
With Indirect
=SUM(COUNTIF(INDIRECT(A1),{1,2}))