View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DEI DEI is offline
external usenet poster
 
Posts: 7
Default Countif using tab range

This seems intuitive to me, but I keep getting an error. I would like to
apply a countif statement to a column in a range of tabs within a workbook,
i.e. =COUNTIF('TAB1:TAB5'!F:F,A2). Is there anyway to do this without
writing a function for each individual column?

Thanks in advance.

DEI