Using COUNTIF with non-adjacent range

  • Thread starter Thread starter Gary
  • Start date Start date
G

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
 
Gary said:
How can I enter a non-adjacent range into the countif
function? . . .
Click to expand...

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