# sum product from multiple sheets with criteria

#### jimblimm

##### Board Regular
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

### Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
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
ABCDEF
1monthemployeeconsecutive days
21sue10sue61
32dave11dave54
43jenny1jenny36
54sue13
65sue14
76jenny15
87dave9
98sue17
109dave10
1110sue7
1211jenny20
1312dave24
consec days

the month column is on both sheets,

i tried the formula and its not working.

the employee is on a seperate sheet

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

Replies
2
Views
115
Replies
1
Views
100
Replies
3
Views
145
Replies
3
Views
143
Replies
2
Views
129

1,203,070
Messages
6,053,366
Members
444,658
Latest member
lhollingsworth

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back