Table of Contents
🔹 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.