sumif..

N

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,
 
F

Fred Smith

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

Or, a Pivot Table.

Regards,
Fred
 
M

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top