| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumif does not calculate beyond 1000 rows
Does anyone know if there is a setting in Excel 2003 where we set number of
rows a formula should pick up? I have a sumif formula to calculate range from row 2 to 20,000. However, it only calculates the first 1000. Then, I have to change the range to 1001 to 2000 for the next set. This only happens on a particular laptop. Thanks, Lisa |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| DGET only limited to 1000 Rows, but I need 8000 rows for DGET funt | Excel Worksheet Functions | |||
| how do i filter a list greater than 1000 rows | Excel Discussion (Misc queries) | |||
| want to limit worksheet to 1000 rows instead of 65,000 | New Users to Excel | |||
| In sheet of 1000+ rows how do I go to last? | New Users to Excel | |||
| how to consolidate large worksheets w/ 800~1000 rows by category? | Excel Worksheet Functions | |||
Threaded Mode
