Peo Sjoblom Wrote:
If you want to sum the Payment column E where A is between certain dates
and
where column H = A6 then you can use
=SUMPRODUCT(--(Payments!$A$2:$A$13=DATE(2004,6,4)),--(Payments!$A$2:$A$13<=DATE(2005,5,4)),--(Payments!$H$2:$H$13=$A6),Payments!$E$2:$E$13)
Thank you! That works, but it still uses absolute references. I've no
problems defining dynamic ranges, but I can't figure out how to
implement dynamic ranges in the SUMPRODUCT formula you've kindly
provided.
Is it possible to use something like this
Code:
--------------------
=SUMPRODUCT(--(payments_range_a=DATE(2004,6,4)),--(payments_range_a<=DATE(2005,5,4)),--(payments_range_h=$A6),payments_range_e)
--------------------
where, for example,
Code:
--------------------
payments_range_e = OFFSET(Payments!$E$1,0,0,COUNTA(Payments!$E:$E),1)
--------------------
?
--
willee
------------------------------------------------------------------------
willee's Profile:
http://www.excelforum.com/member.php...o&userid=31189
View this thread:
http://www.excelforum.com/showthread...hreadid=508589