Filter help

Discuss the spreadsheet application
Post Reply
danonina
Posts: 3
Joined: Sun Aug 05, 2018 12:59 pm

Filter help

Post by danonina »

1Y07QX4.png
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
John_Ha
Volunteer
Posts: 9583
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: Filter help

Post by John_Ha »

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.
LO 6.4.4.2, Windows 10 Home 64 bit

See the Writer Guide, the Writer FAQ, the Writer Tutorials and Writer for students.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
FJCC
Moderator
Posts: 9248
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Filter help

Post by FJCC »

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.
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Post Reply