I am trying to generate a SUMIF statement that looks at the value in COlumn A
to determine if it falls within a range.

DATA
Probability Fees
100% 100
76% 100
75% 100
55% 100
50% 100


To get the results in the table below my thinking was:
For Cell B1 - =SUMIF(A1:a5, .99, b1:b5)
For Cell B2 - =SUMIF(A1:a5, .75 AND <1, b1:b5)
For Cell B3 - =SUMIF(A1:a5, .50 AND <.76, b1:b5)

DESIRED RESULT
100% 100 Confirmed
76% - 99% 100 Probable
51% - 75% 200 Possible

The formula for cell B1 works, but I cannot get the range to work in the
cells for B2 and B3. Am I making any sense?

Much thanks!

Race on,
John