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

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.

--
Dab

Cut off: yourhead to respond

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!
==============================================

"Dab" wrote in message
...
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.

--
Dab

Cut off: yourhead to respond

On Tue, 7 Jun 2005 13:07:03 -0700, "Dab" wrote:

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

Brilliant! (and simple) thanks.

--
Dab

Cut off: yourhead to respond

"RagDyer" wrote in message
...
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!
==============================================

"Dab" wrote in message
...
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.

--
Dab

Cut off: yourhead to respond

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

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

"Dab" wrote in message
...
Brilliant! (and simple) thanks.

--
Dab

Cut off: yourhead to respond

"RagDyer" wrote in message
...
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!
==============================================

"Dab" wrote in message
...
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.

--
Dab

Cut off: yourhead to respond