Forum Discussion
Define a range based on the data in a spreadsheet
I have a two part question. Background: twice a year, I have to process a large spreadsheet of raw data -- it could have 40 columns and over 50,000 or so rows. Each time, the number of rows will b...
Strange that the link does not work anymore.
Try again:
Just build the formula and Excel will insert the structured references instead of the usual cell references.
Okay, success!
The second linked worked.
I had to do a few things manually -- I went to "Formulas -- Name Manager" to rename the table. When replacing the original formula...
=SUMIF($AP$2:$AP54513,"TRUE",$AI$2:$AI54513)
I had to enter the structured references manually. Given the setup in my previous reply, I changed the formula to ...
=SUMIF(My_Table[GoAdd],"TRUE", My_Table[Sales])
It's less important for me to know how many rows there are in My_Table -- I can easily find that the hard way (CNTL-Down Arrow).
Thanks for your help.