Summing values b/t two dates

[starguy]

in col A i have dates in format 5-Mar-06 and in col B i have values. i
want to add values of col B if col A has dates between 1-Mar-06 to
31-Mar-06.
something like this:
sumif(col A has dates b/t 1st & 31st Mar, col B)

 

[Bob Phillips]

=SUMPRODUCT(--(MONTH(A2:A200)=3),B2:B200)

Note that SUMPRODUCT doesn't work with complete columns, you have to specify
a range.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[starguy]

would you please define the role of -- in this formula.

 

[Bob Phillips]

See http://www.xldynamic.com/source/xld.SUMPRODUCT.html for a detailed
explanation.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)