Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sumif - FastExcel
Hi all,
I have a spreadsheet that I have been using for the year and now it is time to update it. The biggest problem with the old one was the re-calculate time. I have 2 worksheets in the workbook, 1 containing data and the other a List of employees (over 500). The List sheet picks up the pay of each staff from the data sheet every month. I used to use an array formula to do this then used a conjoined sumif (Sumif(Range,PayRef&Month&Costcode,Sumrange) with helper column as it was faster, but as the Data sheet gets bigger as the years goes on the recalculate time is now at 12 secs. Is there a faster alternative to Sumif? Is there better method of summing large ranges of data (data sheet contains 14000 rows)? Has anyone used the product FastExcel (www.fastexcel.com) to optimise there spreadsheets and is it any good? All help is greatly ppreciated _______________________ Naz, London |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
How do I use the sumif if I have multiple criteria (i.e. greater . | Excel Worksheet Functions | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions | |||
help with "criterea" in the sumif function | Excel Worksheet Functions | |||
SUM(IF( Array to avoid #NUM! values | Excel Worksheet Functions |