Thread: Formula selecting first 1400 rows of column, need ALL of it. HELP
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Dave is offline
external usenet poster
  
Posts: 1,388
Default Formula selecting first 1400 rows of column, need ALL of it. H
Hi,
Not sure I understand, but here's a suggestion. "cat_col" seems to be a
named range, representing "PRO!$C$2:$C$1400"
Is it just a matter of redefining this named range to "PRO!$C$2:$C$10000" ?
Regards - Dave.

Here's the formula that's in the formula bar: =SUMIF(cat_col,$A157,debit_col)

When I evaluate the formula and then Step in at "cat_col" it expands to
this: "PRO!$C$2:$C$1400"

Reply With QuoteReply With Quote