View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
schillm228
 
Posts: n/a
Default nonadjacent selections

Why can't I use nonadjacent selections as a range in the =COUNTIF formula?

For example: =COUNTIF(FirstGroup,E53)
where FirstGroup is a nonadjacent selection of cells A10:A20 G10:G20