Easiest Way to Calculate Total, Average, Min & Max in Excel!

-

 

Steps to Calculate Total, Average, Min, and Max in Excel



==========================================================================



Step 1: Open Excel and Enter Data

  • Open Microsoft Excel or Google Sheets.
  • Enter the data exactly as shown in the table (May, June, July, August sales for each product).

Step 2: Calculate Total Sales for Each Product

  • In the Total column (e.g., cell G2 for Product A), enter the formula:

=SUM(C2:F2)

Press Enter and drag the formula down for all products.

Step 3: Calculate the Average Sales for Each Product

  • In the Average column (e.g., cell H2), enter the formula:

=AVERAGE(C2:F2)

Press Enter and drag the formula down for all products.

Step 4: Find the Minimum Sales for Each Product

  • In the Min column (e.g., cell I2), enter the formula:
  • =MIN(C2:F2)
  • Press Enter and drag the formula down for all products.

Step 5: Find the Maximum Sales for Each Product

  • In the Max column (e.g., cell J2), enter the formula:

=MAX(C2:F2)

Press Enter and drag the formula down for all products.

Step 6: Calculate Overall Total Sales

  • Below the Total column, enter:

=SUM(G2:G8)

This will give the total sales of all products.

Step 7: Calculate Overall Average Sales

  • Below the Average column, enter:

=AVERAGE(G2:G8)

Step 8: Find the Lowest Sales Value

  • Below the Min column, enter:

=MIN(G2:G8)

Step 9: Find the Highest Sales Value

  • Below the Max column, enter:

=MAX(G2:G8)

Finalizing

  • Adjust the column widths for clarity.
  • Apply formatting such as bold headers and gridlines for better readability.

Once these steps are completed, your spreadsheet will display

Shortcut Key: Alt + M, U, A (this opens the AutoSum dropdown, where you can select Average).

  • *      Calculate MIN (Lowest Sales):
  • *      Click on the cell where you want the lowest sales value to appear (e.g., D8).
  • *      Type the formula =MIN(B2:B6) and press Enter.
  • *      Shortcut Key: There is no direct shortcut key for MIN, so you need to type the formula.
  • *      Calculate MAX (Highest Sales):
  • *      Click on the cell where you want the highest sales value to appear (e.g., E8).
  • *      Type the formula =MAX(B2:B6) and press Enter.

Shortcut Key: There is no direct shortcut key for MAX, so you need to type the formula.

Comments

Post a Comment