# 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: **529 times**

Last updated: **Feb 28 '17**

To display two cells contents together in another cell

Displaying formulas from horizontal block of cells to vertical block of cells [closed]

Calc cells shows only formula and not product/output [closed]

How do I export a chart in an image format from LibreOffice Calc? [closed]

Are there plans for a "papercut" project for libreoffice [closed]

Is it normal for Calc goal seek to take very long? [closed]

Please refine "Search" in Calc - implement functions in Gnumeric [closed]

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