Calculations on a seperate worksheet

[ibf]

I've got a worksheet that I am entering data on. (about 500 rows and about 17 columns) What I would like to do is have a seperate worksheet that I can set up where I do all my different formulas to get different information from the data.

Right now I am doing all the different charts on the same worksheet but I would like to have it on a seperate worksheet.

Here is an example of one of the formulas that I am using.

=SUMPRODUCT((E2:E500="Port Hope")*(G2:G500="MR"),I2;I500

I just can't seem to figure out how to do the calculations on a seperate worksheet.

Help, ibf

 

[Aladin Akyurek]

I've got a worksheet that I am entering data on. (about 500 rows and about 17 columns) What I would like to do is have a seperate worksheet that I can set up where I do all my different formulas to get different information from the data.

Right now I am doing all the different charts on the same worksheet but I would like to have it on a seperate worksheet.

Here is an example of one of the formulas that I am using.

=SUMPRODUCT((E2:E500="Port Hope")*(G2:G500="MR"),I2;I500

I just can't seem to figure out how to do the calculations on a seperate worksheet.

Help, ibf

Prefix the ranges with the shhet name which houses them... For example:

=SUMPRODUCT(--(Data!$E$2:$E$500="Port Hope"),--(Data!$G$2:$G$500="MR"),$I$2:$I$500)

 

[ibf]

Thanks alot Aladin Akyurek for the help

I had tried included the worksheet name but I missed the --and entering them in the ()

ibf