sum product from multiple sheets with criteria

[jimblimm]

my setup

month	employee	consecutive days		sue consecutive total
1	sue	10		61
2	dave	11
3	jenny	1
4	sue	13
5	sue	14
6	jenny	15
7	dave	9
8	sue	17
9	dave	10
10	sue	7
11	jenny	20
12	dave	24

<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>

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)