Summing values b/t two dates

  • Thread starter Thread starter starguy
  • Start date Start date
S

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)
 
=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)
 
Back
Top