Hi!

17424 is calculated in another cell ($L$3) using the MATCH function.

Is that the ACTUAL row reference or is that a RELATIVE row reference. MATCH
returns a RELATIVE value unless you adjust for the offset.

Biff

"Nick" wrote in message
...
I have a Conditional Sum that is used extensively through multipe sheets to
slice and dice a fair amount of raw data. The ending row (17424) changes
each
month. The references to row 17424 is calculated in another cell ($L$3)
using the MATCH function. I would like to substitute the referenced cell
($L$3) for the fixed row number in all formulas using find/replace.

My formulas look like;
=SUM(IF('CDR Data'!$B$4:$B$17424=$M39,IF('CDR
Data'!$O$4:$O$17424=$M$36,'CDR
Data'!E$4:E$17424,0),0))

I used to just extend the range to an extreme (20000) but this now creates
an #N/A in some new formulas that I am using.

Can you show me what the replacement formula should look like using the
$L$3
reference?
--
Thanks,
Nick