#### RandyTampa

##### New Member

- Joined
- Dec 18, 2003

- Messages
- 45

I have several sets of zip codes across a state. I want to take groups of zip codes at a time and apply formulas to all the zip codes in a group at a time. The issue is that not all groups have the same number of zip codes.

For example, group A has 100 zip codes and group B has 74 zip codes.

Formulas might involve summing a column C so that in that column

=sum(D1:D$101) for Group A but for goup B that formula would be sum(D1:D$75).

Since there are dozens of formulas that are dependent upon a given number of rows across many different tabs, it's not feasible to make individual formula changes for each group.

Any advice?

thanks