Sumif with wildcard *

I am using Calc on Libre Office 5.0.2 in windows 7.
I try to using SUMIF with wilcard * but not function.
1 4101A 100
2 4101B 200
3 4101C 300

Can you help me?

You are using wildcards as in Excel. For LO Calc you must precede the asterisk with a period. Replace “4101*” with “4101.*” and your formula should work correctly.

It’s working
only replace * with .

Thankyou verymuch

Support for wildcards in SUM() and related Excel functions will be available in v5.2.0. Refer tdf#72196.