writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 60:
Line 60: − +
no edit summary
=COUNTIF(B2:B7, ">8") : Counts the number of cells in the range B2 to B7 containing number of objects greater than '8', ''returns 3'' as a result.
=COUNTIF(B2:B7, ">8") : Counts the number of cells in the range B2 to B7 containing number of objects greater than '8', ''returns 3'' as a result.
=COUNTIF((B1:B5),"A",11) : Counts the number of cells that contain numbers in the cells B1 to B5 , text value "A" and number '11', ''returns 4'' as a result.
=COUNTIF(A2:A6,A4) : Counts the number of cells in the range A2 to A6, that has text similar to A4, ''returns 1'' as a result.
</div>
</div>