Chart Total

J

John

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?
 
P

Pete_UK

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top