• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

MAXIF Function Help for Multiple Criteria


New Member
Hello - I need help to sort multiple columns for Vendors, hours their employees worked in a week for us, and the latest date (for the latest week they're reporting). Please see the attached file. Column K is where I need the formula for each vendor. For example, I highlighted in light blue what I'm looking for and the answer to populate in the K column. For vendor A, the answer should be 30. Thank you in advance.