Chart Total

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a chart that has 10 colums. In Column 4 it lists account numbers. In
column 8 it lists the dollar amount. The account numbers (in column 4) are
listed more than once. I want to excel to look for the account number and
then add up all the dollar amounts in colum 10 that have that account number
in colum 4. Does that make sense? Would this be a v-look up?
 
Put an account number in cell M1, then in N1 put this formula:

=SUMIF(D$1:D$100,M1,J$1:J$100)

This assumes you have 100 rows of data - adjust to suit.

If you put other account numbers in M2 downwards, then just copy the
formula down to get a sum against each one.

Hope this helps.

Pete
 
Back
Top