Thread: COUNTIF
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default COUNTIF

How about just adding two =countif()'s?

=countif(a1:c10,""&1) + countif(g50:x60,""&1)



Ronbo wrote:

What is the formula (syntax) for counting multiple ranges? I have looked,
and suprisingly not found anything on it.

I am trying to find the number of occurences of a number 1 in ranges A1:c10
and G50:X60.

Thanks for any help


--

Dave Peterson