Filter help

Discuss the spreadsheet application

Filter help

Postby danonina » Sat Aug 11, 2018 12:21 pm


Im trying to find a way in my statistics sheet can filter home and away games. If its a home or a away game is mentioned in the D column. Is there any way to filter it so the calculations in H13-H28 only calculate based on the filter?
OpenOffice 4.1.3 on Windows 10
Posts: 3
Joined: Sun Aug 05, 2018 12:59 pm

Re: Filter help

Postby John_Ha » Sat Aug 11, 2018 2:24 pm

Could you please explain more clearly exactly what you what to do.

Say something like "If D3 is Borla then ...; but if D3 is Hemma then ..." It would also help if you uploaded a small example file.

You will find much useful information in the Calc Guide, the Calc Tutorials and Calc Help. When a popup window opens, click Help for help on that window.
AOO 4.1.5, Windows 7 Home 64 bit

See the Writer Manual, the Writer FAQ, the Writer Tutorials and the Writer guide.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
Posts: 5656
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: Filter help

Postby FJCC » Sat Aug 11, 2018 5:05 pm

If you want to actually filter column D, using Data -> Filter, take a look at the SUBTOAL() function. If you want to have cells permanently displaying values for separate labels in column D, look at the SUMIF() and AVERAGEIF() functions. AVERAGEIF does not appear in the Help but it is available. I agree with John_Ha that an example file would help a lot.
AOO 3.4 or 4.1 on MS Windows XP ( before 2013-08-03) or Windows 7
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Posts: 6615
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Return to Calc

Who is online

Users browsing this forum: No registered users and 37 guests