I have a named range, the contents of which is either a “Y” or it is blank. I want to find all the blank cells and add a number in an adjacent cell to a sum in a different cell. Seems too complicated to me. Is it possible?Banking Test.ods
Could you please elaborate by an simple sample file
- The data you have
- What you want to add, where based on which condition
- How your result should look like
(In fact, I don’t understand your current description of the task to be performed),
Please do **not** use *Add Answer* but **[edit](https://ask.libreoffice.org/t/in-a-named-range-how-do-i-look-for-a-y/63544)** your original question to enhance the details of your question and/or to upload sample file(s) (answers are reserved for solutions to a problem on this Q&A site). Thanks in advance …
SUMIF() should do that.
You need to check for the non-existence of a “Y”, which you may solve by a criterion given as text. To insert a quote character into a quoted string, you type the character twice.
Something like =SUMIF('named range';"<>Y";'summation range')
For summation range, you may also use the OFFSET() function. For an adjacent column, the horizontal offset would be +1 or -1.
Something like =SUMIF('named range';"<>Y";OFFSET('named range';0;1))
Edit: removed quotes which broke the condition. Thanks @EarnestAl
Whoops. For Locale independent =SUMIF(Rec;"<>Y";OFFSET(Rec;0;-1))