Using COUNTIF with non-adjacent range

[Gary]

How can I enter a non-adjacent range into the countif
function? When I hold the Control key and select the
cells of a non-adjacent range commas are put between the
selected cells and the COUNTIF functions thinks I've
entered too many arguments.

I want something like =countif(A1,C1,E1,>2).

I've also tried defining a range and entering that range
name but the COUNTIF function sent back an error message.

Any suggestions????

Thanks....Gary

 

[Harlan Grove]

How can I enter a non-adjacent range into the countif
function? . . .

Not possible. COUNTIF accepts only one single area range as first argument,
even though online help doesn't make this clear.