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