View Single Post
 
Old 05-18-2012, 12:59 PM
CGM3 CGM3 is offline Windows XP Office 2007
Advanced Beginner
 
Join Date: Oct 2009
Posts: 38
CGM3 is on a distinguished road
Default

=SUMIF(range, criteria, sum_range)

where range is (for you) the column of codes (say, A:A), criteria is the code to sum for (in your example, 120), and sum_range is the column with charge amounts (say, B:B). To get the sum of charge amounts associated with code 120, the formula would be:

=SUMIF(A:A, "=120", B:B)
Reply With Quote