Hello,
I have a problem with SUM function in my sheet. The sheet is a template
that I use to export some data into it from external database. Then I
need to count some values. But in design time, I don't know, how many
rows it will be after exporting data. I need to prepare a cell with
SUM(H1:H...someRow) function. My export script will set a value of X1
cell to row count e.g. 52.
How can I use value in X1 as a last row for my SUM function.
SUM(H1:ADDRESS(X1;8)) doesn't work.
Any idea to solve it? Thanks in advance.
Lokutus
--
Lokutus
------------------------------------------------------------------------
Lokutus's Profile:
http://www.excelforum.com/member.php...o&userid=32270
View this thread:
http://www.excelforum.com/showthread...hreadid=520226