Sum cells if third number after comma is 1

Discuss the spreadsheet application

Sum cells if third number after comma is 1

Postby dentopolis » Sun May 10, 2020 8:30 pm

how should I write sum.if when i want to summarize only cells where the third number after comma is 1? ex.20,001, 18,421
LibreOffice 6.4
dentopolis
 
Posts: 15
Joined: Mon Sep 23, 2013 2:44 pm

Re: sum cells if third number after comma is 1

Postby Zizi64 » Sun May 10, 2020 8:40 pm

Sumif with helper column.ods
(9.9 KiB) Downloaded 21 times
Tibor Kovacs, Hungary; LO6.1.6, 6.2.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-6.4.5;AOO4.1.7
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 9540
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary


Return to Calc

Who is online

Users browsing this forum: Google [Bot] and 26 guests