Refer to another worksheet to subtract MAX from MIN if column equals

From Sheet2 need to reference Sheet1 to subtract the MIN from the MAX in column D (formatted NUMBERS) plus 1 only IF column L is equal to 147

In another column from Sheet2 I need to use the formula created for the above and add another criteria that in Sheet1 column F is equal to 1.

Thanks,
Al

Can u provide some sample data so that I can test?

Totals.jpg2012.jpg


Sheet2 is "Totals"
Sheet1 is 2012_V

In the Totals sheet I am trying to get B11 to equal the number of weeks to divide O11 by so that I11 equals the average volume for that machine.

Thanks for your help,

Al

2012.jpg

Here is the 2012_V snap shot

Thanks,
Al