Changes

Jump to navigation Jump to search
no edit summary
Line 14: Line 14:     
COUNTIF(1..1000,"<=10") ''returns 10'' as a result.
 
COUNTIF(1..1000,"<=10") ''returns 10'' as a result.
 +
    
For example, COUNTIF(A1:A8,"JOHN") returns the number of cells in the range A1 through A8 that match with the text "JOHN".
 
For example, COUNTIF(A1:A8,"JOHN") returns the number of cells in the range A1 through A8 that match with the text "JOHN".
writer
2,661

edits

Navigation menu