Thread: SUMIFs for particular cells in blocks of data
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.programming
Spiky Spiky is offline
external usenet poster
  
Posts: 622
Default SUMIFs for particular cells in blocks of data
I would turn your unique identifiers into Named Ranges specifying your
blocks of data. Then it should be easy to do what you want, although
you may need to use INDIRECT to create the references.
Reply With QuoteReply With Quote