SUMIF data that falls within a range

[Racer X]

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

 

[T. Valko]

Try these:

=SUMIF(A1:A5,">0.99",B1:B5)
=SUMIF(A1:A5,">0.75",B1:B5)-SUMIF(A1:A5,">=1", B1:B5)
=SUMIF(A1:A5,">0.50",B1:B5)-SUMIF(A1:A5,">=0.76",B1:B5)

Format as General or Number

 

[Racer X]

Rock and Roll - Thank you!

 

[T. Valko]

You're welcome!

--
Biff
Microsoft Excel MVP

Rock and Roll - Thank you!