View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
George B. George B. is offline
external usenet poster
 
Posts: 2
Default 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.