| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sheet lookup
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| =LOOKUP on another Sheet | Excel Worksheet Functions | |||
| Lookup from other sheet | Excel Discussion (Misc queries) | |||
| lookup with sheet name | Excel Worksheet Functions | |||
| Lookup cell contents in on sheet based on a formula in second sheet | Excel Worksheet Functions | |||
| Lookup from another sheet | Excel Worksheet Functions | |||
Threaded Mode
