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