sum product from multiple sheets with criteria

jimblimm

Board Regular
Joined
May 11, 2012
Messages
219
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
 

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).
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
 
Upvote 0
the month column is on both sheets,

i tried the formula and its not working.

the answers are correct though.
 
Upvote 0

Forum statistics

Threads
1,226,695
Messages
6,192,481
Members
453,727
Latest member
tuong_ng89

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top