Multiple Range Formula
=sumif(a:a,"<20")
=SUMIF(A:A,"<40")-SUMIF(A:A,"<20")
etc.
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"Earl" wrote in message
...
I want to evaluate a column that has multiple, and varied values. Then
return
a value in multiples of '20' in another column. Where 0-19.99='20',
20-39.99='40', 40-59.99='60' etc.
Example:
Calculated Length Nominal Length
5.2 20
20.1 40
42.0 60
64.55 80
|