Alternative to SUMPRODUCT?

roanscar

New Member
Joined
Oct 19, 2006
Messages
3
Is there a formula that I could use instead of SUMPRODUCT? Each person will only have one entry for per day.
Book1
ABCDEFG
1DateEmployeeAmount10/110/2
210/2Bob25Bob4525
310/1Joe30Joe309
410/1Bob45Frank535
510/1Katie15Katie1515
610/2Frank35
710/1Frank5
810/2Joe9
910/2Katie15
Sheet1
[/img][/code]
 

Some videos you may like

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

BruceyBonu$

Board Regular
Joined
Mar 6, 2006
Messages
74
In cell F2

=INDEX($a$2:$c$9,MATCH($e2&"@"&f$1,$b$2:$b$9&"@"&$a$4:$a$10,0),3)
Enter with Ctrl Shift and Enter
 

Watch MrExcel Video

Forum statistics

Threads
1,113,956
Messages
5,545,177
Members
410,668
Latest member
Gaexel
Top