C
Che028
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.
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.