I am using Calc on Libre Office 5.0.2 in windows 7.
I try to using SUMIF with wilcard * but not function.
Ex
A B
1 4101A 100
2 4101B 200
3 4101C 300
=SUMIF(A1:A3;4101*;B1:B3)
Can you help me?
Thankyou
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.