adding cells based on date and text

[dannr]

I know how to use sum product based on Date and Character strings in an array, but now I want to add numbers. For example, I want to calculate all the employee hours entered for July 2007

employee date hours
chuck 07/01/2007 3.50
chuck 07/04/2007 6.75
maggy 07/04/2007 5.0

so maggy should be 5.0 and chuck should be 10.25

 

[Domski]

Hi,

Like this:

Book2
	A	B	C	D	E	F
1	Chuck	01/07/2007	3.5		Chuck	10.25
2	Chuck	04/07/2007	6.75		Maggy	5
3	Maggy	04/07/2007	5
4	Maggy	01/08/2007	7
Sheet3

Dom

 

[lenze]

Hi and welcome to the board!! Have you considered a Pivot Table? It would turn this

  A        B        C     
1 employee date     hours 
2 chuck    7/1/2007 3.5   
3 chuck    7/4/2007 6.75  
4 maggy    7/4/2007 5     
5 Maggy    8/1/2007 3.5   
6 chuck    8/2/2007 4     

Sheet2

[Table-It] version 07 by Erik Van Geit

into this

   E            F        G     
 5 Sum of hours                
 6 date         employee Total 
 7 Jul          chuck    10.25 
 8              maggy    5     
 9 Jul Total             15.25 
10 Aug          chuck    4     
11              maggy    3.5   
12 Aug Total             7.5   
13 Grand Total           22.75 

Sheet2

[Table-It] version 07 by Erik Van Geit

HTH
lenze

 

[dannr]

Thanks everyone for your help! I'll also try a pivot table. If I select "sum" or "count" it may add everything up nicely, but sometimes pivot tables are not smart enough to read your mind! I like SUMPRODUCT cause I can go straight to what I want