writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 16:
Line 16: − +
no edit summary
*Combination of functions can also be used as COUNTIF(A1:A3,"Red")+COUNTIF(A4:A7,"Orange") etc.
*Combination of functions can also be used as COUNTIF(A1:A3,"Red")+COUNTIF(A4:A7,"Orange") etc.
*Wild card characters such as '*', '?', '~' can be used in the criteria field to match a certain sequence of characters.
*Special characters such as '*', '?', '~' can be used in the criteria field to match a certain sequence of characters.
*COUNT() can be used to count the number of cells in the given range except logical values, error values and text.
*COUNT() can be used to count the number of cells in the given range except logical values, error values and text.