Hi,

Am Thu, 14 Jun 2012 23:30:02 +0000 schrieb BDAvs:

Scenario:
Our company has a customer send orders with multiple products and
destinations each day. We have to palletize and assign a pallet number
based on the destination.
Variables:
- Column N has customers: Customers are palletized seperately.
- Column AK has points assign based on the size of the product. No
pallet can hold over 150 points.
- Column AL is my attempt to have a running total that resets itself
after a new customer name begins or a customers quantity hits 150.
(this is the step I need help with)
CURRENT:
=IF(OR((N5=N4)),SUM(AK$5:AK5),AK5)
I have gotten the first cell of the new customer to work, but the sum
function keeps summing up from the first cell because of A$5. How do I
get it to recognize the first cell for a new customer e.g. CELL A33 and
beginning running a sum from there? When new pallet begins, I want the
sum to go 1, 2, 3, 5, etc - not 1, 176, 177, 178, 180, etc.

try:
=IF(N5=N4,SUMIF($N$2:N5,N5,$AK$2:AK5),AK5)


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2