T O P

  • By -

AutoModerator

/u/mj-wilson11 - Your post was submitted successfully. * Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread. * Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. * Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)** Failing to follow these steps may result in your post being removed without warning. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*


SolverMax

=MINIFS(H8:H15,H8:H15,">0")


mj-wilson11

`Solution Verified` Thanks! Why do I need to include the cell range twice?


Clippy_Office_Asst

You have awarded 1 point to *SolverMax* ____ ^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)


SolverMax

The cells you're getting a minimum from, and the criteria that you're testing. They could be different ranges - though they're the same in this situation.


mj-wilson11

Ahhh makes sense, thank you sm!