Excel: Summing values within a certain date range (> start date and < Finish date)
- by Mike
How do I include a 'Between these dates' criteria inside a SUMPRODUCT?
=Sumproduct((RangeName=Cell A1)*(RangeDate=Between 01/03/10 and 31/03/10)*(RangeCost))
What's the way to manage dates (between) in a sum product?
Thanks
Mike