I have data in several non-contiguous ranges that I need to summarize with
COUNTIF. No matter what I do, though, I get a VALUE! error. I know the
problem isn't the source data, since the COUNTF formula works fine if I use
just one of any of the ranges. I've tried this:

=COUNTIF((Q4:Q20,S4:S20,X4:X20),"9/1/2006")

and this:

=COUNTIF((Q4:Q20+S4:S20+X4:X20),"9/1/2006")

and this:

=COUNTIF(Q4:Q20,S4:S20,X4:X20,"9/1/2006")

But these either return VALUE! or (in the last example) are simply plain
wrong because the formula interprets the second two ranges as new arguments.

Help! What am I doing wrong?