If you're *not* talking about totaling,
And mean simply *count* the instances,
use the part of the formulas before the asterisk:

Step value of 1:
=B1-A1+1

Step value other then 1, entered in C1:
=((B1-A1)/C1+1)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Ragdyer" wrote in message
...
When you say "calculate", are you talking about totaling?

If you are,
with starting number in A1, and ending number in B1, and a step value of
1:

=(B1-A1+1)*(A1+B1)/2

If step value other then 1, enter it in C1, then:

=((B1-A1)/C1+1)*(A1+B1)/2

--
HTH,

RD

--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit !
--------------------------------------------------------------------------
-
"ilana" wrote in message
...
I am trying to calculate the step values between a known minimum number
and a
known maxiimum numbers
Any ideas ?