Formula Help Needed
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.
|