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
Copper Contributor
Hi
Use this formula
=COUNTIF(A1:A22,"N")
Use this formula
=COUNTIF(A1:A22,"N")
Georges_Vienna
Jul 13, 2023Copper Contributor
Thank 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, 2023MVP
- Georges_ViennaJul 13, 2023Copper Contributor
SergeiBaklan Thank you!
- SergeiBaklanJul 13, 2023MVP
Georges_Vienna , you are welcome