[Solved] Sum of numbers that have a letter in the cell
[Solved] Sum of numbers that have a letter in the cell
I'm trying to see if I can sum up numbers in a cell if there's a qualifier. For instance, can I place letter in the cell and have my sum function only add up those, and another sum function add up the unqualified numbers?
- Attachments
-
- Barter.xlsx
- (10.04 KiB) Downloaded 172 times
Last edited by MrProgrammer on Sat Dec 27, 2025 5:38 am, edited 1 time in total.
Unspecified version of OpenOffice/LibreOffice. Unspecified operating system.
awascholl needs to update their → forum signature ← (click the link) if they expect to receive appropriate advice for their environment.
-- MrProgrammer, forum moderator
awascholl needs to update their → forum signature ← (click the link) if they expect to receive appropriate advice for their environment.
-- MrProgrammer, forum moderator
Re: Create sum of numbers that have a letter in the cell
Add a column and use SUMIF(), otherwise it will be to complicated.
- Attachments
-
- Barter.ods
- (14.3 KiB) Downloaded 169 times
- MMove 1.0.6
- Extension for easy, exact positioning of shapes, pictures, controls, frames ...
- my current system
- Windows 11 AOO, LO | Linux Mint AOO, LO
Re: Create sum of numbers that have a letter in the cell
Concerning the "Signature":
LO 3.3. was nearly identical to OO.o or AOO V3.
Now we have the stable version 25.2.7 with lots of new features and bugfixes and 25.8 is under ongoing development.
Concerning the topic:
There is an additional example containing some suggestions and explanations:
LibreOffice is still rather rapidly developed.
LO 3.3. was nearly identical to OO.o or AOO V3.
Now we have the stable version 25.2.7 with lots of new features and bugfixes and 25.8 is under ongoing development.
Concerning the topic:
There is an additional example containing some suggestions and explanations:
On Windows 10: LibreOffice 25.8.4 and older versions, PortableOpenOffice 4.1.7 and older, StarOffice 5.2
---
Lupp from München
---
Lupp from München