Does anyone know of good websites detailing mathematical functions
In particuar I would like to explore the code of the excel Sum, Average an count functions and how this is coded in relation to the range paramter

Regards

Mar

I don't believe there is a site that details how sum, average and count are
implemented in code - in any event, they are not written in VB, but rather
in either assembler or C/C++.

I would expect that
Average is defined as sum/count

which would be done with a loop as in the following pseudo code.

cnt = 0
tot = 0
for each cell in Range("A1:A10")
if isnumeric(cell) then
tot = tot + cell.Value
cnt = cnt + 1
end if
Next
Sum = tot
count = cnt
if cnt < 0 then
average = tot/cnt
end if
--
Regards,
Tom Ogilvy



"Mark" wrote in message
...
Does anyone know of good websites detailing mathematical functions?
In particuar I would like to explore the code of the excel Sum, Average an
count functions and how this is coded in relation to the range paramter.

Regards,

Mark

Mark,

You are joking. You think that MS are going to publish their code for the
world to see and copy?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Mark" wrote in message
...
Does anyone know of good websites detailing mathematical functions?
In particuar I would like to explore the code of the excel Sum, Average an
count functions and how this is coded in relation to the range paramter.

Regards,

Mark

http://groups.google.com/groups?selm...%40bigfoot.com

may be what you are looking for.

Jerry

Mark wrote:

Does anyone know of good websites detailing mathematical functions?
In particuar I would like to explore the code of the excel Sum, Average an count functions and how this is coded in relation to the range paramter.

Regards,

Mark