Hi, This is what I have:

A B
1 33 TRUE
2 99 FALSE
3 26 TRUE
4 68 TRUE
5 19 FALSE
6 47 FALSE

What I Need: In this example I want to count how many times or occurances
happen when column B locates a "TRUE" and column A finds only values between
range of 25 thru 50. So the correct result for above example would be 2
occurances, (row 1 & row 3). I know it is a SUMIF situation but can't figure
what it would look like. Thanks in advance for anyones advice!
George B.

=SUMPRODUCT(--(A1:A6=25),--(A1:A6<=50),--(B1:B6=TRUE))

Mangesh



"George B." wrote in message
...
Hi, This is what I have:

A B
1 33 TRUE
2 99 FALSE
3 26 TRUE
4 68 TRUE
5 19 FALSE
6 47 FALSE

What I Need: In this example I want to count how many times or
occurances
happen when column B locates a "TRUE" and column A finds only values
between
range of 25 thru 50. So the correct result for above example would be 2
occurances, (row 1 & row 3). I know it is a SUMIF situation but can't
figure
what it would look like. Thanks in advance for anyones advice!
George B.

give this formual a try...

=SUMPRODUCT((A1:A65535=25)*(A1:A65535<=50)*(B1:B6 5535))
--
HTH...

Jim Thomlinson


"George B." wrote:

Hi, This is what I have:

A B
1 33 TRUE
2 99 FALSE
3 26 TRUE
4 68 TRUE
5 19 FALSE
6 47 FALSE

What I Need: In this example I want to count how many times or occurances
happen when column B locates a "TRUE" and column A finds only values between
range of 25 thru 50. So the correct result for above example would be 2
occurances, (row 1 & row 3). I know it is a SUMIF situation but can't figure
what it would look like. Thanks in advance for anyones advice!
George B.

Thank you Mangesh & Jim! Both formulas work superb! I really appreciate
your help!
Thanks again, George B.

"George B." wrote:

Hi, This is what I have:

A B
1 33 TRUE
2 99 FALSE
3 26 TRUE
4 68 TRUE
5 19 FALSE
6 47 FALSE

What I Need: In this example I want to count how many times or occurances
happen when column B locates a "TRUE" and column A finds only values between
range of 25 thru 50. So the correct result for above example would be 2
occurances, (row 1 & row 3). I know it is a SUMIF situation but can't figure
what it would look like. Thanks in advance for anyones advice!
George B.