sum product from multiple sheets with criteria

[jimblimm]

my setup

[TABLE="width: 451"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD]month[/TD]
[TD]employee[/TD]
[TD]consecutive days[/TD]
[TD][/TD]
[TD]sue consecutive total[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]sue [/TD]
[TD]10[/TD]
[TD][/TD]
[TD]61[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]dave [/TD]
[TD]11[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]jenny[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]sue [/TD]
[TD]13[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]sue [/TD]
[TD]14[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]jenny[/TD]
[TD]15[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]dave [/TD]
[TD]9[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]sue [/TD]
[TD]17[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]dave [/TD]
[TD]10[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]sue [/TD]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]jenny[/TD]
[TD]20[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]dave [/TD]
[TD]24[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


month and employee column is on sheet "month"

consecutive days is on another sheet

"consec days"

the months on "month" sheet are relevant to the "consec sheet"

i am looking for a formula that will add the entries for sue on "consec days" sheet.

which would be....
month 1, 4, 5, 8, 10 on sheet "consec days"

which would equal 10+13+14+17+7 =61

 

[Robert Mika]

I'm consfused with your set up.
Is the row on "consec days" relevant to row on "month" sheet?
This is based on one sheet but please explain your set op a little bit more to give more correct answer

Excel Workbook
	A	B	C	D	E	F
1	month	employee	consecutive days
2	1	sue	10		sue	61
3	2	dave	11		dave	54
4	3	jenny	1		jenny	36
5	4	sue	13
6	5	sue	14
7	6	jenny	15
8	7	dave	9
9	8	sue	17
10	9	dave	10
11	10	sue	7
12	11	jenny	20
13	12	dave	24
consec days

 

[jimblimm]

the month column is on both sheets,

i tried the formula and its not working.

the answers are correct though.

 

[jimblimm]

the employee is on a seperate sheet

=SUMIF('month'!$B$2:$B$13,"sue",'consec days'!$C$2:$C$13)