GrapeCity Forums

hello

i have formula like this : SUMIF(B:B;"101*";E:E)

and i expect sum of every value in column E for every data in column B like "101*"

but it dos not work likely it work exactly mod and return zero . problem with asterisk regular expression

ebsaso,

In Excel, the SUMIF function supports wildcard characters in the criteria parameter.  The question mark '?' matches any single character.  The asterisk '*' matches any sequence of characters.  In Excel, the criteria "101*" would match any string value that begins with "101".

In Spread Win, the SUMIF function does not support wildcard characters in the criteria parameter.  In Spread Win, the criteria "101*" only matches the string value "101*".