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

Last updated: **Feb 28 '17**

How to make one cell equal another in Calc?

How to Reference the value of the filter in autofilter?

Inconsistencies with border width settings [closed]

Writer: how to change style for all formulas

Delete blank entries rows [closed]

[Calc] Combined charts with independent Y axis [closed]

Why can't the compiler find the method getActiveSheet? [closed]

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