ExcelBanter - sumif..

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - sumif.. (https://www.excelbanter.com/excel-worksheet-functions/261072-sumif.html)

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,

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

Or, a Pivot Table.

Regards,
Fred

"nordiyu" wrote in message
...
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,

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<=DA TE(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<=DA TE(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,

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" wrote in message
...
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,