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?