Adjusting Formula in a New Worksheet

[thekid22]

Hi all

I have a worksheet called 'Data' which I insterted a table into with cell formula:
=SUMPRODUCT((TEXT(B2:B1032,"mmmyy")="Feb15")*(G2:G1032="Client"))
The formula was pulling every time both "2/xx/2015" came up in column B and the value "Client" in column G
I have decided to move this table to a separate worksheet but when I changed the formula in the new worksheet to pull from the 'Data' sheet it doesn't return any results. How can I alter this formula to pull from 'Data'?

=SUMPRODUCT(TEXT('Data'!B2:B1032,"mmmyy")="Feb15")*('Data'!G2:G1032="Client")

Thank you!

[p24leclerc]

as this is a formula that uses cells value from another workbook, you need to reference that workbook in the formula. The easiest to do so is to have both workbook open at the same time and then you write your formula SUMPRODUCT by selecting cells in the other workbook. The reference is added automatically.
When you will close the other workbook, the reference will add the full path to the file.