Getting sum of values in another sheet while using condition
Hi,
Am Thu, 21 Mar 2013 13:00:51 +0000 schrieb ser_man:
Hi, i'm looking to get a sum of values in a range of dates from one
sheet and to have the sum in another sheet.
for example i define in the second sheet that the range of dates is
3/4/12 to 3/3/13 The function will lookup the dates range and will sum
the values that appear in the 2nd coloum. anyone got any ideas?
try:
=SUMPRODUCT(--(Sheet1!$A$1:$A$1000=DATE(2012,4,3)),--(Sheet1!$A$1:$A$1000<=DATE(2013,3,3)),Sheet1!$B$1: $B$1000)
Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
|