Summing values b/t two dates
 

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)


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=535885

Summing values b/t two dates
 

=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" wrote in
message ...

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)


--
starguy
------------------------------------------------------------------------
starguy's Profile:
http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=535885

Summing values b/t two dates
 

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


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=535885

Summing values b/t two dates
 

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"starguy" wrote in
message ...

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


--
starguy
------------------------------------------------------------------------
starguy's Profile:
http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=535885