tow criteria (Date and Name)in sumif
 

in a1,2,3,4 i have Name(brian,brenda,chris)
in b1,2,3,4 i have $ (500, 150,200)
in c1,2,3,4 I have Date (1/15/2006, 2/20/2006, 1/20/2006)
the result i need is: how many money brian in january, februar and so on.
Hope i get help and thank you in advance.

tow criteria (Date and Name)in sumif
 

Don't use sumif, go ahead and use

=Sumproduct (--(range=condition),--(range=condition),range)

The last range is to add how much money

--------------------------------------------------------------------------------
Sam Sebaihi Faculty Western International University Associate Programs
"Rolf" wrote in message
...
in a1,2,3,4 i have Name(brian,brenda,chris)
in b1,2,3,4 i have $ (500, 150,200)
in c1,2,3,4 I have Date (1/15/2006, 2/20/2006, 1/20/2006)
the result i need is: how many money brian in january, februar and so on.
Hope i get help and thank you in advance.

tow criteria (Date and Name)in sumif
 

Hi Rolf

Create a Pivot Table.
First create a Dynamic Range
InsertNameDefineName MyRange Refers to
=($A$A1,0,0,COUNTA($A:$A),3)

Place cursor on row 1.
DataPivot TableNextRange =Myrange Finish
Drag Name to Column Area
Drag $ to Data Area
Drag Date to Row Area
Click on Date field and from the PT toolbar select Group and Shoe
DetailGroupMonth


For more help on Pivot Tables
Take a look at the following sites
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html

http://www.datapigtechnologies.com/f...es/pivot1.html

http://www.edferrero.com/Tutorials.aspx



--
Regards

Roger Govier


"Rolf" wrote in message
...
in a1,2,3,4 i have Name(brian,brenda,chris)
in b1,2,3,4 i have $ (500, 150,200)
in c1,2,3,4 I have Date (1/15/2006, 2/20/2006, 1/20/2006)
the result i need is: how many money brian in january, februar and so
on.
Hope i get help and thank you in advance.