COUNTIFS with OR instead of AND

[bakerjay]

The COUNTIFS function seems to do an 'AND' between each clause.
I am looking for something similar which does an 'OR' between the clauses instead.

Any ideas would be much appreciated...
Thanks
Jay

[shg]

=sum(countifs(myrange, {1,2,3}))

[Colin Legg]

Note that you will only be able to do "OR" conditions twice within the COUNTIFS. The first array constant is horizontal while the second array constant is vertical.

=SUM(COUNTIFS(myrange1, {1,2,3} , myrange2, {1;2;3} ))