A string criterion must be enclosed in quotation marks. To match an actual question mark or asterisk, prefix the character with the tilde ( ~) character (i.e. criterion can contain wildcards including ? to match any single character or * to match zero or more contiguous characters. If range contains text to check against, criterion must be a string. ![]() Range - The range which is tested against criterion.Ĭriterion - The pattern or test to apply to range. ![]() Returns a conditional sum across a range.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |