How do you use the Max if function?

I'm trying to understand how to use the Max if function in Excel or a similar program. I want to know how it works and how I can apply it to my data to find the maximum value based on certain conditions.