Countif with OR

[pedie]

Hi, I need formula for Countif with OR
B2 = Count if A1= Xs1 or Count if A2= 9.5
My result should be 1 if A1/A2 = "" or any other critiria there.
But if any of or both of the cells meets the critiria still answer will be 1

 

[Trevor G]

You should be able to adapt this

=COUNTIF($D$2:$L$2,{"A"})+COUNTIF($D$2:$L$2,{"B"})+COUNTIF($D$2:$L$2,{"C"})

 

[pedie]

Trevor, i have tried this...'=SUM(COUNTIF(B2:B15,$A$16),COUNTIF(B2:B15,$F$22)) also the formula you gave ..'=COUNTIF(B1:B15,A17)+COUNTIF(B1:B15,G23)
but it gives result as 2....


A16 has = Xs1 or Count if F22 has = 9.5 and the result should be = 1 though both has the critiria

 

[pedie]

okay this formula works perfect.
=IF($A$16="x",COUNTIF(B2:B15,"x"),COUNTIF(B2:B15,"y")) but when i enter the time it does not work. Please help.

 

[Trevor G]

Can you use Excel Jeanie to show some of the table and then explain what you need, by refering to time it doesn't help without seeing the data.