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.