SUMIF date criteria
in [Functions]
|
Prev: Pivot Tables - get a total different than the summarize field sett
Next: Count occurences of same zip codes
From: CSam on 15 Dec 2009 14:03 Can anyone help with a Date range criteria in a SUMIF statement. I'm trying to add up Values in line 4 between 2 dates a b c d e f 1 start 11/11 2 end 13/11 3 dates 10/11 11/11 12/11 13/11 14/11 4 value 2 3 4 5 6 5 sumif(be:f3,">="&b1,b4:f4) will do more or = to one date how do i do a range. Any help would be welcome Thanks
From: Per Jessen on 15 Dec 2009 14:11 Hi Try this formula: =SUMIF(A3:E3,">="&A1,A4:E4)-SUMIF(A3:E3,">" &A2,A4:E4) Regards, Per "CSam" <CSam(a)discussions.microsoft.com> skrev i meddelelsen news:858B9D71-9970-4153-A0C9-60C5E9478E8C(a)microsoft.com... > Can anyone help with a Date range criteria in a SUMIF statement. > I'm trying to add up Values in line 4 between 2 dates > > a b c d e f > 1 start 11/11 > 2 end 13/11 > 3 dates 10/11 11/11 12/11 13/11 14/11 > 4 value 2 3 4 5 6 > 5 > > sumif(be:f3,">="&b1,b4:f4) will do more or = to one date how do i do a > range. > Any help would be welcome > > > Thanks
From: Bernard Liengme on 15 Dec 2009 14:46 How about sumif(be:f3,">="&b1,b4:f4) - sumif(be:f3,">="&b2,b4:f4) You should check where to use >= or > If you have Excel 2007+ then ise SUMIFS best wishes -- Bernard Liengme http://people.stfx.ca/bliengme Microsoft Excel MVP "CSam" <CSam(a)discussions.microsoft.com> wrote in message news:858B9D71-9970-4153-A0C9-60C5E9478E8C(a)microsoft.com... > Can anyone help with a Date range criteria in a SUMIF statement. > I'm trying to add up Values in line 4 between 2 dates > > a b c d e f > 1 start 11/11 > 2 end 13/11 > 3 dates 10/11 11/11 12/11 13/11 14/11 > 4 value 2 3 4 5 6 > 5 > > sumif(be:f3,">="&b1,b4:f4) will do more or = to one date how do i do a > range. > Any help would be welcome > > > Thanks
From: Ashish Mathur on 19 Dec 2009 06:49
Hi, Try this =sumproduct((b3:f3>=B1)*(b3:f3<=b2)*(b4:f4)) -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "CSam" <CSam(a)discussions.microsoft.com> wrote in message news:858B9D71-9970-4153-A0C9-60C5E9478E8C(a)microsoft.com... > Can anyone help with a Date range criteria in a SUMIF statement. > I'm trying to add up Values in line 4 between 2 dates > > a b c d e f > 1 start 11/11 > 2 end 13/11 > 3 dates 10/11 11/11 12/11 13/11 14/11 > 4 value 2 3 4 5 6 > 5 > > sumif(be:f3,">="&b1,b4:f4) will do more or = to one date how do i do a > range. > Any help would be welcome > > > Thanks |