🔹 How to Sum Values for a Specific State in Excel

📌 Formula to Sum Only ‘Delhi’ Amounts:

=SUMIF(C:C, "Delhi", D:D)

🔹 Explanation:

  • C:C → The column where states are listed.
  • “Delhi” → The condition to filter only “Delhi”.
  • D:D → The column where amounts are stored.

Example:

Leave a Reply

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

Pinterest
Instagram