Ask Your Question
0

sumif with wildcard *

asked 2015-09-30 08:50:02 +0100

herry gravatar image

updated 2015-09-30 17:00:31 +0100

Alex Kemp gravatar image

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

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
0

answered 2015-09-30 16:26:39 +0100

LKeithJordan gravatar image

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.

edit flag offensive delete link more

Comments

It's working only replace * with .

Thankyou verymuch

herry gravatar imageherry ( 2015-10-02 04:29:29 +0100 )edit
0

answered 2016-02-21 08:34:36 +0100

oweng gravatar image

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

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

2 followers

Stats

Asked: 2015-09-30 08:50:02 +0100

Seen: 953 times

Last updated: Feb 21 '16