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

Which function to uss to sum categories in a list?
 

Data/Subtotals - at each change in description, use function Sum on the
column with you quantity.

"kdnichols" wrote:


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

Which function to uss to sum categories in a list?
 

Use DATA - SUBTOTALS.

"kdnichols" wrote:


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