OR Operator in Excel

[Peteor]

I have got to be missing something simple here. I have the following code where "1" appears 3 times and "5" appears 1 time in Range("A1:A25")...

=COUNTIF(A1:A25,OR(1,5))

Which I would think should return "4", but it is returning "0"... Does anyone have any input? (web searching isn't really helpful here)

 

[RoryA]

To calculate that, you can either add two separate COUNTIF formulas, or use an array like this:

=SUM(COUNTIF(A1:A25,{1,5}))

 

[Peteor]

That's the one. Thank you!