Forum Discussion
ohillaryo
Jun 28, 2023Copper Contributor
Count a Value When Sorted
Hi! I simply need to count the number of times "N" appears in a column but have it updated to the accurate count once another column is sorted. Why can't I figure out what is probably pretty easy??...
MayHlaing
Jun 29, 2023Copper Contributor
Hi
Use this formula
=COUNTIF(A1:A22,"N")
Use this formula
=COUNTIF(A1:A22,"N")
- Georges_ViennaJul 13, 2023Copper ContributorThank you. Could you also tell me how I can combine two (or more) IF-Sections. In the case at hand I would like to count the number of the combination of "N" in Column A for example and "Y" in Column B for example.
- SergeiBaklanJul 13, 2023Diamond Contributor
- Georges_ViennaJul 13, 2023Copper Contributor
SergeiBaklan Thank you!