Thread: countif with two sets of non consectutive ranges at the same time
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default countif with two sets of non consectutive ranges at the same time
If you have XL-2007
use COUNTIFS function. It's more elegant than COUNTIF(rng1)+COUNTIF(rng2)

"Gover" wrote:

I need to count how many times 10 appears in a row. but the row has been
split up. the data is in a1:f1 then more in m1:z1. the countif function
will not let me have more than one consectuive stretch for its range.

any suggestions

Reply With QuoteReply With Quote