Chart Total

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

John - 14 Sep 2007 17:02 GMT

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?

Reply to this Message

Pete_UK - 14 Sep 2007 23:33 GMT

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

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

Reply to this Message

Rate this thread: