Referring to a range with variable rows

[Laurence Lombard]

In the array formula below I would like to have row 5043 variable - it
should be the last row of the range. I can create a Named Range called
LASTROW = COUNTA("Cash Bks"!$A:$A) [column A contains reference numbers}
How can I use this in the formula: =SUM(('Cash Bks'!$J$3:$J & LASTROW...
does not work


=SUM(('Cash Bks'!$J$3:$J$5043=B8)*('Cash Bks'!$K$3:$K$5043=$D$3)*('Cash
Bks'!$G$3:$G$5043))


Thanks
Laurence

 

[Jim Rech]

Perhaps a better way to do this with a variable is to use the OFFSET
function. A simple example would be:

=SUM(OFFSET(A1,,,COUNTA(A:A),1)*C3)