sumif..
in [Functions]
|
From: nordiyu on 8 Apr 2010 22:51 my condition is : A B C 1 Date Name $ 2 15/2/10 John 15 3 16/2/10 Mike 8 4 28/2/10 John 21 5 01/3/10 John 10 6 05/3/10 Mike 15 What the formula to get total $ John in month feb. / mar Name Total $ Feb Total $ Mar John ? ? Rgds,
From: Fred Smith on 9 Apr 2010 00:13 =sumproduct(--(text(a2:a6,"yyyymm")="201002"),--(b2:b6="John"),(c2:c6)) Or, a Pivot Table. Regards, Fred "nordiyu" <nordiyu(a)discussions.microsoft.com> wrote in message news:A88F167B-2B98-48C1-816F-F07B5F744E44(a)microsoft.com... > my condition is : > A B C > 1 Date Name $ > 2 15/2/10 John 15 > 3 16/2/10 Mike 8 > 4 28/2/10 John 21 > 5 01/3/10 John 10 > 6 05/3/10 Mike 15 > > > What the formula to get total $ John in month feb. / mar > > Name Total $ Feb Total $ Mar > John ? ? > > > > Rgds,
From: Ms-Exl-Learner on 9 Apr 2010 03:30 If you want to sum all the C Column values of John then use the below formula. =SUMIF(B:B,"JOHN",C:C) If you want to sum the values of John based on the DATE FALLING ONLY IN FEBRUARY then use the below formula. =SUMPRODUCT((A2:A200>=DATE(2010,2,1))*(A2:A200<=DATE(2010,2,28))*(B2:B200="JOHN"),(C2:C200)) If you want to sum the values of John based on the DATE FALLING FROM FEBRUARY TO MARCH then use the below formula. =SUMPRODUCT((A2:A200>=DATE(2010,2,1))*(A2:A200<=DATE(2010,2,31))*(B2:B200="JOHN"),(C2:C200)) -- Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "nordiyu" wrote: > my condition is : > A B C > 1 Date Name $ > 2 15/2/10 John 15 > 3 16/2/10 Mike 8 > 4 28/2/10 John 21 > 5 01/3/10 John 10 > 6 05/3/10 Mike 15 > > > What the formula to get total $ John in month feb. / mar > > Name Total $ Feb Total $ Mar > John ? ? > > > > Rgds,
From: Ashish Mathur on 12 Apr 2010 03:25 Hi, You may also create a pivot table, where you may drag names to the row area, dates to the column area and US$ to the data area. Now click on any data in the column area of the pivot and Group the dates by months -- Regards, Ashish Mathur Microsoft Excel MVP "nordiyu" <nordiyu(a)discussions.microsoft.com> wrote in message news:A88F167B-2B98-48C1-816F-F07B5F744E44(a)microsoft.com... > my condition is : > A B C > 1 Date Name $ > 2 15/2/10 John 15 > 3 16/2/10 Mike 8 > 4 28/2/10 John 21 > 5 01/3/10 John 10 > 6 05/3/10 Mike 15 > > > What the formula to get total $ John in month feb. / mar > > Name Total $ Feb Total $ Mar > John ? ? > > > > Rgds,
|
Pages: 1 Prev: hyperlink help Next: How do I filter cells based on character case in Excel |