View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ken Ken is offline
external usenet poster
 
Posts: 590
Default COUNTIF with non-continuous range

Can I use the COUNTIF function on an area that does not have a continuous
range?

Example:

=COUNTIF(AG4:AG25,AA4:AA26,U4:U26,B4:B26,H4:H26,N4 :N26,AZ4:AZ25,AT4:AT25,AN4:AN25,1)

Generates an error - too many arguments. I have also tried it with quotes:

=COUNTIF("AG4:AG25,AA4:AA26,U4:U26,B4:B26,H4:H26,N 4:N26,AZ4:AZ25,AT4:AT25,AN4:AN25",1)

But this, too, generates a general error.

Suggestions? I have a complex spreadsheet and I need to count values all
over it.