total row max number in Excel

Q3. In an Excel table, how can I add a Total Row that displays the maximum value in a column of numbers?

For example, the Table below lists the Quarter wise Sales data in the Year 2016 for all Salespersons in a Company. I would like to identify the Maximum Sales by a Salesperson in each Quarter.

excel total row max number

To do it in Excel, here is the answer:

To add a Total Row that displays the maximum value in a column of numbers in a Table,

a) Click on any cell in the Table. In the Ribbon, "Table Tools" Design tab appears. Click on "Total Row" under "Table Style Options". "Total Row" appears at the end of the Table.

excel excel total row max number

b) Click on cell in Total Row for the column for which Max value is to be determined. In the drop down, select Max. Repeat this step for the remaining 3 columns with Sales data.

excel excel excel total row max number

 

You can find similar Excel Questions and Answer hereunder

1) How can I get row count of filtered data?

2) How do I get the 2nd highest number in a range of numbers?

3) Can I apply formatting to a number concatenated with a Text?

4) How do I change the rating numbers to rating labels?

5) Can I determine the number of times a character appears in a cell using formula?

6) How to disable ability to insert Rows and Columns in Excel (using VBA)?

7) Vlookup to return max value from multiple hits in Excel

8) Millions thousands custom number formatting in Excel

9) How do I get the rank of a number in a list of numbers?

10) How can I generate random numbers between 2 limits?

11) Vba delete entire row if contains certain text in Excel

12) How to freeze a row or column in Excel

13) Highlight row of selected cell in Excel

14) How can I find number of months that has elapsed given 2 dates?

15) How can I get the last non-zero value in a row?