Help with function to sum values in a worksheet depending on account number

[Dab]

I think I know the answer to this already but I thought I'd ask anyway

I have a large spread sheet table detailing many items each identified by
account numbers. The account numbers may occur in several different lines
in the table.

I know that I could do this with a macro or VB Script but what I'm wondering
is if there is an Excel function That will look up all the occurrences of a
particular account numbers in a table, and sum the total dollar value for
all of the occurrences of that particular account number? Basically, I need
dynamic sort (and sum) of the table by account numbers without changing the
original table.

Let me know if you have any suggestions. Thanks.

 

[RagDyer]

The SUMIF() function should do exactly what you need.
Check it out in the Help files.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

 

[Ron Rosenfeld]

I think I know the answer to this already but I thought I'd ask anyway

I have a large spread sheet table detailing many items each identified by
account numbers. The account numbers may occur in several different lines
in the table.

I know that I could do this with a macro or VB Script but what I'm wondering
is if there is an Excel function That will look up all the occurrences of a
particular account numbers in a table, and sum the total dollar value for
all of the occurrences of that particular account number? Basically, I need
dynamic sort (and sum) of the table by account numbers without changing the
original table.

Let me know if you have any suggestions. Thanks.

SUMIF worksheet function would seem to be ideal for this.


--ron

 

[Dab]

Brilliant! (and simple) thanks.

 

[RagDyer]

FAR from brilliant, but thanks for the feed-back.