SUMIF data that falls within a range

R

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top