[Solved] Get a sum of numbers within a specific range

Discuss the spreadsheet application

[Solved] Get a sum of numbers within a specific range

Postby eng215 » Sun May 02, 2021 6:13 pm

I am trying to get the sum of all numbers in a column that are less than 38

A1 = 5
A2 = 40
A3 = 3
A4 = 4
A5 = 50

The answer should be 12
Last edited by MrProgrammer on Wed May 12, 2021 10:13 pm, edited 1 time in total.
Reason: Tagged ✓ [Solved]
OpenOffice 4.1.7 on Windows 7 Premium
eng215
 
Posts: 2
Joined: Wed Mar 10, 2021 9:20 pm

Re: How to get a sum of numbers within a specific range

Postby Zizi64 » Sun May 02, 2021 6:29 pm

Study and use the SUMIF() function.
Tibor Kovacs, Hungary; LO6.1.6, 6.4.7 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.1.1;AOO4.1.9
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: 10096
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: How to get a sum of numbers within a specific range

Postby Villeroy » Sun May 02, 2021 6:45 pm

Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
Villeroy
Volunteer
 
Posts: 30283
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Calc

Who is online

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