View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sherry N. Sherry N. is offline
external usenet poster
 
Posts: 15
Default Sum based on value between two cells

Hello,
I have 3 fields, Date, OldestDate and Received. I need to sum the values of
Received between, when Date = Oldestdate. For instance below:

I want to sum the range (Received) between 1/12/2009 in the Date field and
1/12/09 in the OldestDate field for a total of 558.


Date OldestDate Received
1/12/2009 12/23/2008 208
1/13/2009 12/23/2008 20
1/14/2009 12/23/2008 44
1/15/2009 12/23/2008 81
1/16/2009 12/23/2008 42
1/19/2009 1/12/2009 163

Thanks.


--
Sherry N.