[Solved] Dropdown Menu, Conditional Sum, Function list: help

Discuss the spreadsheet application
Post Reply
GhettoT
Posts: 3
Joined: Fri May 23, 2008 11:55 pm

[Solved] Dropdown Menu, Conditional Sum, Function list: help

Post by GhettoT »

Hi,

Here is what I am trying to do.
I have a column that I want to be a dropdown menu with two options, Yes and No
Each row would be specified as either the "yes" or "no" option, then I want to have a single sell (with the "conditional adding") that says,

Code: Select all

IF row = "yes" -> add row value to the total 
ELSE IF row = "no" -> DO NOTHING
I've been trying to figure this out for a while now to no prevail. Any help would be greatly appreciated.
Last edited by GhettoT on Sat May 24, 2008 8:16 pm, edited 1 time in total.
User avatar
squenson
Volunteer
Posts: 1885
Joined: Wed Jan 30, 2008 9:21 pm
Location: Lausanne, Switzerland

Re: Dropdown & "COnditional Adding" help

Post by squenson »

The SUMIF function should be the answer. Have a look at the attached example.
Attachments
SumIf2.ods
(9.12 KiB) Downloaded 496 times
LibreOffice 4.2.3.3. on Ubuntu 14.04
GhettoT
Posts: 3
Joined: Fri May 23, 2008 11:55 pm

Re: Dropdown & "COnditional Adding" help

Post by GhettoT »

Thats exactly what i needed. Thank you very much. Also, is there a wiki or something or the sort that has a list of all the functions? Also, how did you create that dropdown?

Thanks so much.
User avatar
squenson
Volunteer
Posts: 1885
Joined: Wed Jan 30, 2008 9:21 pm
Location: Lausanne, Switzerland

Re: Dropdown & "COnditional Adding" help

Post by squenson »

I am using the standard help file or I click on the f(x) symbol left to the formula bar when I am looking for a function.

To create a dropdown box, select your cell range and click on the menu Data > Validity. In my example, I use a List, as the value are fixed and will not probably change, but I often use a separate range of cells which allow kind of dynamic update of the choices in the dropdown list.

If your question is answered, please edit your first post and add "[Solved]" (without the quotes) at the beginning of the subject. It helps others to quickly find solutions to similar problems.
LibreOffice 4.2.3.3. on Ubuntu 14.04
GhettoT
Posts: 3
Joined: Fri May 23, 2008 11:55 pm

Re: Dropdown & "COnditional Adding" help

Post by GhettoT »

Yes it is, thank you very much.
Post Reply