MAXIF formula in Excel

20 pts.
Tags:
Microsoft Excel
microsoft excel functions
Excel has SUMIF and COUNTIF functions, but I don't find a comparable MAXIF function. Can such a function be added into Excel? Any suggestions for sources?
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

If you copy and paste one of the sample formulas, make sure you change smart quotes to ordinary ones.
Whether formula is copied or typed, press CONTROL SHIFT ENTER while still in edit mode to convert to array formula or you will see #VALUE error.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: