#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11
Default sumif..

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,
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,389
Default sumif..

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


  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 132
Default sumif..

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,

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,766
Default sumif..

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,


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A" Harry Seymour Excel Worksheet Functions 9 June 12th 07 10:47 PM
SUMIF help! Xenos Excel Worksheet Functions 4 September 25th 05 03:25 PM
Embedding a Sumif in a sumif C.Pflugrath Excel Worksheet Functions 5 August 31st 05 07:31 PM
nested sumif or sumif with two criteria dshigley Excel Worksheet Functions 5 April 5th 05 03:34 AM
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function Oscar Excel Worksheet Functions 2 January 12th 05 12:01 AM


All times are GMT +1. The time now is 01:09 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"