formula help

M

mikeeee

I am using a formula =COUNTIF('CONTROL GROUP 3'!H6:H313,"no info")
and I need to include other criteria in addition to "no info" such a
"12th", "11th", etc. The formula works fine the way it is with n
errors but I need to include the other criteria but when I add th
other criteria I get an error message that the formula is no longe
valid the way I have typed it. Can someone show me how to add the othe
criteria and still make the statement (formula) valid?

Thanks
Mik
 
P

Peo Sjoblom

Are you counting cells that have either no info or 12th?

=SUMPRODUCT(('CONTROL GROUP 3'!H6:H313="no info")+('CONTROL GROUP
3'!H6:H313="12th"))

or just 2 countif formulas added

If you want AND criteria and the 12th etc would be in another column?

=SUMPRODUCT(--('CONTROL GROUP 3'!H6:H313="no info"),--('CONTROL GROUP
3'!I6:I313="12th"))


will count H6:H313 with no info WHERE I6:I313 holds 12th

Regards,

Peo Sjoblom
 
A

Alex

Hello

So I take it you mean you want to make a count of cells that, for example,
contain 'no info' and '12th'?

You can just 'add' two formulas e.g.

=COUNTIF('CONTROL GROUP 3'!H6:H313,"no info") + COUNTIF('CONTROL GROUP
3'!H6:H313,"12th")

This ought to work. Maaybe there is a neater way but that is the first thing
that springs to mind.

Let me know if that solves your problem.

Alex
 
Top