tow criteria (Date and Name)in sumif

R

Rolf

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.
 
S

SAM SEBAIHI

Don't use sumif, go ahead and use

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

The last range is to add how much money
 
R

Roger Govier

Hi Rolf

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

Place cursor on row 1.
Data>Pivot Table>Next>Range =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
Detail>Group>Month


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/flashfiles/pivot1.html

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