If you have a single criterion right now but plan to add a couple more in the future, then always prefer to use the COUNTIFS function in such a scenario. Thus, there are a total of nine test scores that are greater than 40 in our dataset.ĬOUNTIF is a great alternative if you want to count the cells ‘only and only when’ you intend to use a single criterion. When we combine both the conditions, the formula becomes =COUNTIFS(C3:C12,">40",C3:C12,"40") in cell F5 which gives the result as 9.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |