Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date & Time | New Users to Excel | |||
Function to list values of last 3 non-blank cells in a vertical bl | Excel Worksheet Functions | |||
Indirect( ) function loosing values when spreadsheets are closed | Excel Worksheet Functions | |||
Excel: Add "dBm" and "dBW" to CONVERT worksheet function Power u. | Excel Worksheet Functions | |||
left worksheet function within a combo box | Excel Worksheet Functions |