sumif..

[nordiyu]

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,

 

[Fred Smith]

=sumproduct(--(text(a2:a6,"yyyymm")="201002"),--(b2:b6="John"),(c2:c6))

Or, a Pivot Table.

Regards,
Fred

 

[Ms-Exl-Learner]

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))

 

[Ashish Mathur]

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