Hi

Is there a combination of functions that I can use to
return the row/reference of a specified text in a column
then use this reference in another function not to return
a value for cells in a column after that row?


Thanks.

You probably need to rephrase that question, maybe you could use index and
match or offset and match
but I don't understand this part

"then use this reference in another function not to return
a value for cells in a column after that row?"

If you meant summing a column but not beyond that particular cell, then the
answer is yes
but you need to explain further


--

Regards,

Peo Sjoblom




"nc" wrote in message
...
Hi

Is there a combination of functions that I can use to
return the row/reference of a specified text in a column
then use this reference in another function not to return
a value for cells in a column after that row?


Thanks.