# How to SUMIF that tests if length of cell is 1

Consider the following:

What is the formula that "sums column C if the length of the corresponding cell in column A is =1" ?

First time here? Check out the FAQ!

How to SUMIF that tests if length of cell is 1

Consider the following:

What is the formula that "sums column C if the length of the corresponding cell in column A is =1" ?

add a comment

2

Hallo

Solution with the *Swiss-Army-Knife* in terms of functions:

`=SUMPRODUCT(LEN(A1:A4)=1, C1:C4)`

Aha! I agree, this was what I was looking for! Thanks :)

0

If you use wildcards in formulas (default for recent LO versions), then you may use `"=?"`

as criteria. If you use regular expressions, your criteria will be `"=."`

. See `Tools`

->`Options`

->`LibreOffice Calc`

->`Calculate`

for settings that control using regexes/wildcards in formulas.

I have wildcards on. Not sure how to write it. Do you mean =SUMIF(A1:A4,LEN(=?)=1,C1:C4) ? This formula doesn't work.

1

Asked: ** 2017-02-28 12:01:57 +0200 **

Seen: **258 times**

Last updated: **Feb 28 '17**

Display percent value as progress bar, in cell? [closed]

Empty cell as result of formula [closed]

How do I get the worksheet name, into a cell

To display two cells contents together in another cell

Counting/Restart Count based on another column [closed]

Is there a formula that would pull cell content based on the content of cell x?

Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.