Home |
Search |
Today's Posts |
#1
|
|||
|
|||
DSUM frustrations
Thanks, but does not look like DSUM does what I want e.g no way of getting it to count those bloomin pear tree profits! I have over a thousand part no's in a spreadsheet and a qty against those part no's but I have a problem where there maybe a qty of 8 and then another row which has the same part no with a qty of 9. what I'm trying to do is get a unique list of part no's with the total qty of the part no. DSUM looked my best hope but that seems too limited. My hope was I could have a qty DSUM for each row and the I could delete the other qty column and the filter it by unique records giving me a list of unique parts no's and total usage's with no duplicates. Please can anybody help, I don't want to do it by hand. Thanks Paul -- Paul Adams ------------------------------------------------------------------------ Paul Adams's Profile: http://www.excelforum.com/member.php...o&userid=10468 View this thread: http://www.excelforum.com/showthread...hreadid=277659 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formulas SUMIF & DSUM | Excel Discussion (Misc queries) | |||
DSUM and other functions on External data | Excel Discussion (Misc queries) | |||
DSUM frustrations | Excel Worksheet Functions |