Pls help- Dates

[Dharsh]

Hi- since the english version id not working I am trying
my luck here. Can someone pls help me.

I have data in 2 columns and want to add the data in the
2nd column within a period ie within a certain date for
e.g add 2nd column between 16/03/2005 and 17/03/2005. Can
someone pls help me Pls.

16/03/2005 8
16/03/2005 8
17/03/2005 10
17/03/2005 -4
18/03/2005 5
18/03/2005 8
21/03/2005 1
21/03/2005 1

Thanks in advance

 

[Bill Manville]

If you put the startdate of the period in D1 and the end date in D2,
and the dates are in column A and the values in column B, rows 1 to
1000:

=SUMIF(A1:A1000,">="&D1,B1:B1000)-SUMIF(A1:A1000,">"&D2,B1:B1000)

This assumes that the dates are numerical date values rather than text
strings (ie they change format if you use Format / Cells / Number).
It also assumes you want to sum where the date is between D1 and D2
inclusive.

Bill Manville
MVP - Microsoft Excel, Oxford, England