Imagine you spent about an hour writing and testing a solution for someones
problem, all for free and good will. This person doesn't immediately
understand it, so he speed-types "this doesn't make any snese" and click
Send. Your response would of course be "this nice person with the great
manners really shows me the respect I deserve".

"SailFL" skrev i melding
...
The only one with bad manners here is you, Harald. Because some one
doesn't
know how to do some thing or doesn't understand is not a problem here.
That
is the purpose of these message boards. So he can't type big deal. I bet
you didn't always know everthing!
--
SailFL


"Harald Staff" wrote:

It makes perfect sense, you're just too ignorant to implement it. If
your
manners weren't as bad as your spelling then someone might consider
helping
you with it.

"Robert" skrev i melding
...
This doesn't make any snese. How do I put this formula in a macro.
Please
explain. Thankks.
--
RSF


"Biff" wrote:

Hi!

Column A = decimal values
Column B = integer values

D1 = 1
E1 = 1.3

=SUMPRODUCT(--(A1:A5=D1),--(A1:A5<=E1),B1:B5)

Biff

"Robert" wrote in message
...
I am trying todo something which I "thought" would be simple.

I have a column of number from 0 through 77. I have another
column
beside
of it. The numbers are like this:

1 5
1.1 6
1.3 4
1.35 5
1.5 6

All the way to 77.

I am trying to write a code in VBA that says, basically, if the
value
in
this cell is between (for instance, 1 and 1.3 then sum the values
from
the
corresponding column. The answer to the above would be 15. ELSE,
if
the
values are between 1.35 and 1.5, then sum the values in the
corresponding
column (the answer being 11) and so on. I wanted to store the
answer
values
in specified cells on the same worksheet. Can someone please
help?
Thanks.
--
RSF