Sum if between 2 dates

[faisal.ta]

Hi
In Cell A 1-50 we have various dates of say 1 to 30 Dec
In Cell B 1-50 against the date we have various quantities

The formula needed is if i need to all the quantites between 1st to 5th December what should be the formula for the same.
If anyone can guide

[Pete_UK]

Suppose you put the 1st December in C1 and the 5th December in D1, then you can use this formula in E1:

=SUMIFS(B:B,A:A,">="&C1,A:A,"<="&D1)

You can only use SUMIFS if you have XL2007 or later. If you are using XL2003, as your profile states, then you can use this:

=SUMIF(A:A,">="&C1,B:B) - SUMIF(A:A,">"&D1,B:B)

Hope this helps.

Pete