SUMIF data that falls within a range
 

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

SUMIF data that falls within a range
 

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

--
Biff
Microsoft Excel MVP


"Racer X" wrote in message
...
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

SUMIF data that falls within a range
 

Rock and Roll - Thank you!

"Racer X" wrote:

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

SUMIF data that falls within a range
 

You're welcome!

--
Biff
Microsoft Excel MVP


"Racer X" wrote in message
...
Rock and Roll - Thank you!

"Racer X" wrote:

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