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