## Max of a certain Criteria

Hi there, If I am trying to find the maxiumum value of all cells that fit a certain criteria what formula could I use? For example, lets say I have 10 rows of …

Hi there, If I am trying to find the maxiumum value of all cells that fit a certain criteria what formula could I use? For example, lets say I have 10 rows of …

Hi below is a basic spreadsheet for what i require. In the RATE cells i need the following input. I want a search to be done in the REd category column. …

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners. How Google uses data when you use our partners' sites or apps

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.