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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

keeping same-row(or column) cell constant in a formula while drag- 1
Mapping integers to strings 5
How can I use the * wildcard in an array formula 4
Formula to use date in file name link reference 2
Calculating a sum from a given number of rows 3
Percentile function using a cell reference for the array 1
Formula Help 2
Adding up total hours worked on employee schedule using various criteria 0

Back
Top