Hi, I want to perform calculations on data based on the contents of two fields.
LOWER UPPER OCCUR.
IRON 65.299 99999.990 20
SILICA 2.849 3.651 20
MANGA 0.999 1.401 20
DEMI 0.000 23.001 13
IDEAL 72.999 99999.990 13
-1/4" 0.000 0.501 23
1/4AT" 94.499 99999.990 22
COMPRESSION 529.999 99999.000 20
The Lower and Upper columns contain the Max Min values that data inside another column could contain. Each field example Iron contains data for the month. I need a formula that will count the number entries that fall inside the Upper and Lower interval and places the result inside the OCCUR field.
Hope this is clear enough.
Thx
LOWER UPPER OCCUR.
IRON 65.299 99999.990 20
SILICA 2.849 3.651 20
MANGA 0.999 1.401 20
DEMI 0.000 23.001 13
IDEAL 72.999 99999.990 13
-1/4" 0.000 0.501 23
1/4AT" 94.499 99999.990 22
COMPRESSION 529.999 99999.000 20
The Lower and Upper columns contain the Max Min values that data inside another column could contain. Each field example Iron contains data for the month. I need a formula that will count the number entries that fall inside the Upper and Lower interval and places the result inside the OCCUR field.
Hope this is clear enough.
Thx