You've got me on the logic issue. First, the subject title is a bit of a misnomer. What I am trying to do is to stop pulling data from some columns (E,F,G,H) and start pulling data from another column (I) when a cell value (J3) exceeds 20. Yet, I need to add the number from column I to sumE13:H13 when J3 was at 20.

Second, the "dog" table is not the true application data. The real scenario is, I believe, too detailed to try to explain here. Because of that, I created this as an example. The overall concept is basically the same, so I am going to try to explain my problem using this example. If I still cannot explain it well enough, I can try explaining the "true" application later. I am not trying to deceive anyone by doing this, I just think it will be easier.

With that said:

Consider this to be a spreadsheet for determining how much dog food to have in-house based on the number of dogs (both number of breed and total number of dogs) for a kennel.

The numbers in E3:H3 are the total number of dogs for that breed. These numbers are increased over time, and there are actually 28 columns including the "over 20" column. The numbers for each breed could range from 0 to 30. (therefore there are 30 rows of corresponding numbers)

The total number of dogs in the facility is J3.

The numbers in E4:H10 are cases of dog food. The amount of dog food needed is based on the number of dogs of that breed in the facility. These numbers are constant.

J2 is the number of dogs above 20.

J13 is the total number of cases of dog food needed in-house.

What I need to do is "freeze" the values in E13, F13, G13, and H13 when the total dogs = 20. If any more dogs are added, I want to add the corresponding number from column I to the total returned when dogs = 20 (sum of E13:H13). The 21st dog would add I4 and the total @ 20. The 22nd would add I5 to the total @ 20 etc.

I hope my babbling did not confuse you any further.

Dave

Of all the things I've lost, I miss my mind the most.