• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 184
  • Last Modified:

Excel SUM with matching condition

I need to get a sum of rows where the "Country" column is equal to "China".   How do I do this?   "Country" is column AE.
1 Solution
Assume Country - Column AE, and the range to sum is AF:

You can use SUMIF

=SUMIF(AE:AE,"China",AF:AF) ' put this in the cell where you want the result

If you know the bounds of the data, you can include them, e.g., Assuming data starts on row 2:


would give you the sum where data is in rows 2-100

The syntax is:


Zack BarresseCEOCommented:
While Dave gave you the answer you're looking for, I'd like to probe a little more.  What version are you running?  How is your data structured?  You might be able to benefit from a PivotTable (probably THE best feature Excel has to offer - well, not including PowerPivot ;) ).  Just curious.

Zack Barresse
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now