Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

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. Ex A B 1 4101A 100 2 4101B 200 3 4101C 300 =SUMIF(A1:A3;4101*;B1:B3)

Can you help me? Thankyou

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. Ex A B 1 4101A 100 2 4101B 200 3 4101C 300 =SUMIF(A1:A3;4101*;B1:B3)

Can you help me? Thankyou