The correct syntax for the COUNTIF function is “COUNTIF=(field_range, criteria)”. The field range is also written as “range” in some programs, such as Microsoft Excel 2016. It is used to count the number of cells that fit a certain criteria. It can be a little tricky to program it correctly, but there are plenty of tutorials online to help you do this correctly. In the range, you enter two cell numbers.
This is the range of cells you want counted. The criteria makes sure you get the number of cells that match a certain parameter search. For example, you could count all the cells between A2 and D5 for values less than $200 if you’re making a spreadsheet of monetary values.
Answer Anonymously
Copy Link
