Go to https://sheets.google.com in a web browser. If you’re not already signed in to your Google account, follow the on-screen instructions to sign in now.
Click the file you want to edit. If you prefer to create a new spreadsheet, click the box with a “+” at the top-left corner of the list.
Double-click the empty cell where you want the count to appear. This is where you’ll enter the formula.
Type =COUNTIF( into the cell.
Select the cells you want to count. To do this, click and drag the mouse over the entire range. This adds the range to the COUNTIF formula. You can also type the range manually in the following format: B2:C4.
Add qualifying criterion after a comma. To count every selected cell regardless of its value, skip this step. Otherwise, type a , and then type the criteria between quotes (""). Here are some examples: To count only the cells in B2:C4 with values over 50, your formula would look like =COUNTIF(B2:C4,">50" To count only the cells in B2:C4 that say “Yes,” your formula would look like =COUNTIF(B2:C4,"Yes".
Type ) at the end of the formula. This closes the formula. Example without criterion: =COUNTIF(B2:C4) Example with criterion: =COUNTIF(B2:C4,">50")
Press ↵ Enter or ⏎ Return. The count of selected cells that meet the entered criteria (if applicable) now appears in the cell.
Comments
0 comment