ExcelBanter - Sheet lookup

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Sheet lookup (https://www.excelbanter.com/excel-discussion-misc-queries/131399-sheet-lookup.html)

I have a table in a main spreadsheet 'current' that uses the formula
=SUMPRODUCT((MONTH(A1:A10000)=1)*(AP1:AP10000) but the table is affecting
the performance of the rest of the sheet and it keeps freezing so I'd like to
move the results table to an individual sheet 'costings'. How do I adjust
the formula to do this?

Do you just need to precede the ranges with the sheet name, like
Costings!A1:A10000?

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"judgejulz" wrote in message
...
I have a table in a main spreadsheet 'current' that uses the formula
=SUMPRODUCT((MONTH(A1:A10000)=1)*(AP1:AP10000) but the table is affecting
the performance of the rest of the sheet and it keeps freezing so I'd like
to
move the results table to an individual sheet 'costings'. How do I adjust
the formula to do this?