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


On Sep 14, 5:02 pm, John <J...@discussions.microsoft.com> wrote:
> 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?