software

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: www.excelforum.com/member.php...oamp;userid=34586
View this thread: www.excelforum.com/showthread...hreadid=543591Data/Subtotals - at each change in description, use function Sum on the
column with you quantity.

quot;kdnicholsquot; wrote:

gt;
gt; Hello All,
gt;
gt; I have rows of data where I want to break on two or more items that are
gt; the same and get the total for them.
gt;
gt; Would I use an IF statement or an IIF statement?
gt;
gt; What are your suggestions and why?
gt;
gt; Lets say we have
gt;
gt; Sort Order Item Code Max Count Quantity Description
gt; 10 888 50 32
gt; apple
gt; 10 888 50 22
gt; apple
gt;
gt; I want it to break on description each time and sum the quantity for
gt; the apple description.
gt;
gt; What is the most efficient way to do this?
gt;
gt; Thanks,
gt;
gt; Kurt
gt;
gt;
gt; --
gt; kdnichols
gt; ------------------------------------------------------------------------
gt; kdnichols's Profile: www.excelforum.com/member.php...oamp;userid=34586
gt; View this thread: www.excelforum.com/showthread...hreadid=543591
gt;
gt;

Use DATA -gt; SUBTOTALS.

quot;kdnicholsquot; wrote:

gt;
gt; Hello All,
gt;
gt; I have rows of data where I want to break on two or more items that are
gt; the same and get the total for them.
gt;
gt; Would I use an IF statement or an IIF statement?
gt;
gt; What are your suggestions and why?
gt;
gt; Lets say we have
gt;
gt; Sort Order Item Code Max Count Quantity Description
gt; 10 888 50 32
gt; apple
gt; 10 888 50 22
gt; apple
gt;
gt; I want it to break on description each time and sum the quantity for
gt; the apple description.
gt;
gt; What is the most efficient way to do this?
gt;
gt; Thanks,
gt;
gt; Kurt
gt;
gt;
gt; --
gt; kdnichols
gt; ------------------------------------------------------------------------
gt; kdnichols's Profile: www.excelforum.com/member.php...oamp;userid=34586
gt; View this thread: www.excelforum.com/showthread...hreadid=543591
gt;
gt;