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