Ask Your Question
0

sumif with wildcard * [closed]

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

herry gravatar image

updated 2020-08-30 11:19:07 +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 reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-08-30 11:19:54.148737

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

Question Tools

2 followers

Stats

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

Seen: 1,536 times

Last updated: Feb 21 '16