Sheet lookup

J

judgejulz

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

Bob Phillips

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