1️⃣ Calculate the Sum Using Quick Analysis

📌 Steps:

  1. Select the data range (B2:E3).
  2. Click on the Quick Analysis tool (or press CTRL + Q).
  3. Click on Totals → Sum to get row-wise and column-wise totals.

2️⃣ Calculate the Percentage Using Quick Analysis

📌 Steps:

  1. Select the total values you just calculated.
  2. Click on the Quick Analysis tool (CTRL + Q).
  3. Choose % (Percentage) under the Totals section.
  4. Excel will automatically calculate and format percentages.

Now, Excel quickly shows both the sum and percentage with just a few clicks! 🚀

Example:

Leave a Reply

Your email address will not be published. Required fields are marked *

Pinterest
Instagram