=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.