What next? Metacharacters in Excel functions
The next version of EasyXLS will support metacharacters for SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFS, COUNTIF, COUNTIFS, DAVERAGE and DCOUNTA functions from MS Excel.
The metachars like *, ? and ~ are used for defining the criteria parameter for the above functions.
Find more details about working with formulas and functions in Excel and how to use ?formula calculation engine???.