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.
saturationAsked:
Who is Participating?
 
dlmilleConnect With a Mentor Commented:
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:

=SUMIF(AE$2:AE$100,"China",AF$2:AF$100)

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

The syntax is:

=SUMIF(range,criteria,[sum_range])

Dave
0
 
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.

Regards,
Zack Barresse
0
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.

All Courses

From novice to tech pro — start learning today.