| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
won't calculate far enough
Hello,
I have a formula (see below) that will work for rows 2-1000, but once I change it to look for columns beyond 2000, it will not work anymore... Any suggestions? This works: =SUMPRODUCT(--('Q Info'!$A$2:$A$1000= 'Per Peice'!A9),'Q Info'!$C$2:$C$1000*'Q Info'!$B$2:$B$1000) This DOESN'T work: =SUMPRODUCT(--('Q Info'!$A$2:$A$9999= 'Per Peice'!A9),'Q Info'!$C$2:$C$9999*'Q Info'!$B$2:$B$9999) -- Nicki Taylor |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I calculate hours in Excel | New Users to Excel | |||
| Spreadsheet Won't Calculate | Excel Discussion (Misc queries) | |||
| help with sumif to calculate column | Excel Discussion (Misc queries) | |||
| How can I calculate Vacation Time earned based on length of emplo. | Excel Discussion (Misc queries) | |||
| formula to calculate # of days between dates, excluding holidays | Excel Discussion (Misc queries) | |||
Threaded Mode
