Can a Named constant be used to reference a row in a formula?

  • Thread starter Thread starter Toby Erkson
  • Start date Start date
T

Toby Erkson

Can a constant be used to reference a row?

For example, with the following snippet of my formula:
{=SUM(IF(('SIEBEL EXPORT'!$G$2:$G$65000="Won")*('SIEBEL...}
I would like to make the value 65000 a Named constant, like 'MaxRows'. Thus, I would have something like so:
{=SUM(IF(('SIEBEL EXPORT'!$G$2:$G$MaxRows="Won")*('SIEBEL...}

However, this does not work. Please note that I am using an array formula...don't know if this makes a difference.

Toby Erkson
Oregon, USA
 
Hi
try
{=SUM(IF((INDIRECT("'SIEBEL EXPORT'!$G$2:$G$" &
MaxRows)="Won")*('SIEBEL...}

--
Regards
Frank Kabel
Frankfurt, Germany

Can a constant be used to reference a row?

For example, with the following snippet of my formula:
{=SUM(IF(('SIEBEL EXPORT'!$G$2:$G$65000="Won")*('SIEBEL...}
I would like to make the value 65000 a Named constant, like
Click to expand...
'MaxRows'. Thus, I would have something like so:
{=SUM(IF(('SIEBEL EXPORT'!$G$2:$G$MaxRows="Won")*('SIEBEL...}

However, this does not work. Please note that I am using an array
Click to expand...
formula...don't know if this makes a difference.
 
Back
Top