View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Seanie Seanie is offline
external usenet poster
 
Posts: 202
Default COUNTIF Non Contiguous Cells Q

I want to create a formula that will Count the number of times cells
is a range are greater than 1.

Ordinarly I would use the formula =COUNTIF(F$10:F$168,"0"), however
my range is non-contiguous, it is however relative, in that the cells
I wish to Count are always 3 apart.

So if I was to avoid having to long type a formula with all the ranges
I want to count, how would I do it?

Thanks