Hi Max,

I couldn't find that thread this morning for some reason (this is my very
first and only thread here)

Pls read this thread again, I think it better explain what I'm trying to do.

Again the source data is always changing that's why I couldn't add them
(although I still could be able to see the numbers), and the only data
registered a real number is the LAST SET (see explaination above)

thanks for your help

Henry

"Max" wrote:

It's a pity that you seem to have deserted your earlier thread despite the
patience of 2 responders who hung in there with you to try and get you going:

http://tinyurl.com/cry7ba

My last response to you in that thread was:
.. still, the results are zeros.

Believe you may not be array-entering the formulas correctly ..

In the formula bar, did you see the curly braces { } inserted by Excel
around the formula, viz. it should look like this:
{=SUM(A1:A4+0)}


If you don't see the curlies, then it wasn't confirmed correctly. Re-click
inside the formula bar, press CTRL+SHIFT+ENTER to confirm it, then check for
the curly braces again in the formula bar

--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---