help witha countif function using a date range

[the bail]

Hi guys,

I'm having difficulty in writing a formula. I have a large data table that has a date in column A and a figure in column B.

What I want is a formula that will count the values in column B if the date in column A is within a certain range.

Any suggestions?

 

[VoG]

Do you mean sum rather than count?

Excel Workbook
	A	B	C	D	E
1	12/01/2012	1	01/02/2012	01/03/2012	4
2	19/01/2012	1
3	26/01/2012	1
4	02/02/2012	1
5	09/02/2012	1
6	16/02/2012	1
7	23/02/2012	1
8	01/03/2012	1
9	08/03/2012	1
10	15/03/2012	1
Sheet9

 

[the bail]

Yes, sorry.

I see what you have done. So i sould put start and end date for the range I want covered into another column on the sheet?

 

[VoG]

That is the easiest way.

 

[the bail]

Done and Done,

Thank you so much for your help with this VoG!
Now back to my table. It dates back to 2004! I thought I would be here for an eternity! Still might be if I hit any more brick walls!