Thread: Multiple countif()s or a better way?
View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike Echo
 
Posts: n/a
Default Multiple countif()s or a better way?
In article ,
says...

Well, she works beautifully. I didn't get the {3,4,5,6,0} bit until I
realised that you were grouping cells into blocks of 7 (MOD()) and then
determining which ones should be matched ({3,4,5,6,0}). The 0 threw me
until I remembered computers always start at 0 (my Monday is in cell Q,
a 3). Is this basically how it works?

Thanks very much for taking the time, Bob.
R.
Reply With QuoteReply With Quote