Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Which function to uss to sum categories in a list?
Hello All, I have rows of data where I want to break on two or more items that are the same and get the total for them. Would I use an IF statement or an IIF statement? What are your suggestions and why? Lets say we have Sort Order Item Code Max Count Quantity Description 10 888 50 32 apple 10 888 50 22 apple I want it to break on description each time and sum the quantity for the apple description. What is the most efficient way to do this? Thanks, Kurt -- kdnichols ------------------------------------------------------------------------ kdnichols's Profile: http://www.excelforum.com/member.php...o&userid=34586 View this thread: http://www.excelforum.com/showthread...hreadid=543591 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What function to select the last 3 small values from a list ? | Excel Discussion (Misc queries) | |||
What function to select the last 3 small values from a list ? | Excel Worksheet Functions | |||
need function to sum top ranking items in list | Excel Worksheet Functions | |||
Creating Drop Down boxes with the List function... | Excel Discussion (Misc queries) | |||
If function using a list of criteria | Excel Discussion (Misc queries) |