[Solved] MINIF and MAXIF Formulas

[~~puzzled~~]

Have very basic understanding of constructing OpenCalc formulas and would very much appreciate some help. Have successfully used Formulas for AVERAGEIF, COUNTIF, etc, but need two examples to work from to gain MINIF and MAXIF. Any help you provide will potentially assist in seeing more of my State's newspapers digitised online.

I'm trying to find the Minimum and Maximum values in a column on a separate worksheet where a text value is present in another column's corresponding cell (on that same worksheet) and is greater than 0. For instance I have one column with the electoral regions of Victoria (Australia) (i.e. "Eastern Metropolitan", "Eastern Victoria", "Southern Metropolitan" etc.). The data I'm trying to extract from is in individual columns depending on what Newspaper Directory it appeared in.

Looking at Help there appears to only be a MIN function not a MINIF or MINIFS function, as is possible with AVERAGEIFS, COUNTIFS, etc or is available in Excel. This means I will presumably have to construct an IF statement that incorporates MIN to achieve my desired outcome. From memory I read somewhere I have to hold CTRL, SHIFT and another key before activating the formula to convert to a special kind of formula. I've succesfully constructed a formula that returns the MIN or MAX in the entire cell, but not specifically the MIN or MAX for that electoral region (as defined by entry in column D).

The cell range with the electoral regions specified is "Sheet.1.D2:Sheet1.D1401". An electoral region listed in the D range is "Eastern Victoria". One of the columns to extract the MIN or MAX value from is "Sheet1.AC2:Sheet1.AC1401". I want the Minimum value greater than 0, this will then return me the result of the MINIMUM "entered" pagination for that corresponding directory.

Any help you can provide in solving this will be appreciated by myself and users of digitised newspapers. Thanks for any help you provide.

[Villeroy]

LibreOffice Calc has MAXIFS and MINIFS.

https://www.libreoffice.org/discover/li ... penoffice/

[MrProgrammer]

Hi, and welcome to the forum.

I'm trying to find the Minimum and Maximum values in a column on a separate worksheet where a text value is present in another column's corresponding cell (on that same worksheet) and is greater than 0.

For assistance with solutions for OpenOffice attach a document demonstrating the situation (remove confidential information then use Post Reply, not Quick Reply, and don't attach a picture instead of the document itself). Specify the cell which contains the value to match in column D and specify the cell which is to display this minimum value.

[Tutorial] Ten concepts that every Calc user should know