Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Look Up Formula Help Needed | New Users to Excel | |||
Excel formula to copy/paste formula needed please. | Excel Discussion (Misc queries) | |||
formula needed please | Excel Discussion (Misc queries) | |||
Formula needed | Excel Discussion (Misc queries) | |||
Formula Needed! | Excel Discussion (Misc queries) |