The COUNTIF function in Google Sheets lets you analyze data in your spreadsheet and returns the number of times it appears in your document if it meets a set of specific criteria. Here’s how to use it.
Use COUNTIF to Match on One Type of Criteria
Fire up Google Sheets and open a spreadsheet with data you want to count.
Click on an empty cell and type =COUNTIF(<range>,<criterion>) into the cell or the formula entry field, replacing <range> and <criterion> with the range of data to count and the pattern to test, respectively. It should look something like this:
=COUNTIF(F2:I11,"<=40")
After you press the “Enter” key, the cell will contain the number of times the range matches the exact criteria specified.
If the range you want to count contains a string of text in it, it would look something like this:
=COUNTIF(C2:C11,"George")
Read the remaining 12 paragraphs
from How-To Geek https://ift.tt/378SqLq
No comments:
Post a Comment