![]() Press SHIFT+CTRL+ENTER simultaneously to apply the formula. Go to the Review tab then un-select the 'Protect Workbook' button and your Freeze Panes should work again (I'm on 2010, but I assume 2016 has a similar layout). ![]() Excel Details: Re: Freeze Panes greyed out Your worksheets aren't protected, but your work book is. Criteria_range1 is the Sales Rep Column ( B4:B19) Freeze Panes greyed out - Excel Help Forum.Criteria1 is the name of the Sales Rep ( F4).Criteria_range2 Is the category Column ( C4:C19).Criteria2 is the name of the Category ( G4).Max_range is the Total Sale column ( D4:D19).=MAX(IF(criteria_range1=criteria1, IF(criteria_range2=criteria2, max_range))) We want to find the maximum sales of Alex under Computer Category. how to use if function in excel - 'if' statement is a important function for beginner and advance user.The if statement returns a true value. Now we have to find the highest number of sales made by these Sales Reps in each category.Ĭreate a table anywhere in the worksheet and the Name and the Category column insert the given criteria.Īpply the MAX IF formula. Most of the time, finding a cell in an Excel spreadsheet is pretty easy if you can’t just scan through the rows and columns for it, you can use CTRL+F to search for it. Let’s assume that we have more than one Sales Rep named Alex, Bob, and John in Computer, Cycle, and Medicine category. Sometimes we have to find the maximum value by satisfying multiple criteria. For the other two names, we will use the same formula. Since this is an array formula we have to complete this formula by closing all the brackets.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |