Counting Entries between two dates

[albertmb]

Hi Everyone, I need help.
In Column 'A' I have all the days in a year. In Colomn 'B' I enter numbers
representing bank deposits. Is it possible to have a formula counting
deposits between two specific dates?
EX:

Sheet 1
Column A Column B
01/01/08 € 200
02/01/08 € 150
03/01/08 € 140
04/01/08 € 100

Sheet 2

(Date From) 01/01/08 (Date to) 03/01/08 = € 490

Thank You for your kind help

Abert

 

[Max]

One way:
=SUMPRODUCT((A1:A4>=--("1 Jan 2008"))*(A1:A4<=--("31 Mar 2008")),B1:B4)
Adapt the ranges to suit
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,800 Files:359 Subscribers:55
xdemechanik

 

[albertmb]

Thank You Max, woorked to perfection.

One way:
=SUMPRODUCT((A1:A4>=--("1 Jan 2008"))*(A1:A4<=--("31 Mar 2008")),B1:B4)
Adapt the ranges to suit
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,800 Files:359 Subscribers:55
xdemechanik

 

[Max]

Welcome
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,800 Files:359 Subscribers:56
xdemechanik