Counting Entries between two dates
 

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

Counting Entries between two dates
 

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" wrote:
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

Counting Entries between two dates
 

Thank You Max, woorked to perfection.

"Max" wrote:

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" wrote:
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

Counting Entries between two dates
 

Welcome
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,800 Files:359 Subscribers:56
xdemechanik
---
"albertmb" wrote in message
...
Thank You Max, woorked to perfection.