| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Help, I need a formula for work.
Help, I need a formula for work.
Here is a generic version of my problem Leauge Team Attendance exceed 20,000? American Yankees Yes American Red Sox No National Phillies Yes National Mets Yes National Giants Yes National Dodgers No American Twins No American Angels Yes =COUNTIF(E3:E10,"YES") Total would be 5 "YES'' Answers ______________________________________________ Now the spreadsheet is FILTERED to only show "AMERICAN" Leauge Team Attendance exceed 20,000? American Yankees Yes American Red Sox No American Twins No American Angels Yes =COUNTIF(E3:E10,"YES") Does anybody know of a formula that I may use the same range (e3:e10) but now since it is FILTERED the answer would be 2 instead of 5? Any help would be greatly appreciated. Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I Need get work this formula | Excel Worksheet Functions | |||
| IF-then formula doesn't work | Excel Discussion (Misc queries) | |||
| Why does this formula not work? | Excel Discussion (Misc queries) | |||
| FORMULA DOESN'T WORK | Excel Discussion (Misc queries) | |||
| A search for $ in a formula use to work now it does not work | Excel Discussion (Misc queries) | |||
Threaded Mode
