Filter help
Filter help
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
Re: Filter help
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.
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.
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.
Re: Filter help
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.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.