View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Miguel Zapico
 
Posts: n/a
Default Find category value based on date range?

Sure, I use to recommend this link, it has good examples and explanations:
http://www.ozgrid.com/Excel/DynamicRanges.htm

Miguel.

"thewiz1972" wrote:

Very cool. Perhaps you could answer one more question for me.
In Sheet2 I will be adding new bills from time to time so is there a
way to properly reference this dynamic range in the formula you've
provided?

Thanks,
-Mark