For example:

Column C has a bunch of numerical values for which I'd like to get the MIN,
MAX, Average, etc of. But, I don't always want to do the entire column.
There are "chunks" of data that I'd like to perform the operations on.

So, I figure out the chunks automatically and place them in Column N. So,
Column N looks like this:

N1=C1
N2=C8
N3=C2350
N4=C3458

What'd I'd like to do is this:

Min(C1:C8)
Min(C8:C2350)
Min(C2350:C3458)

But, I'd like to use the values that are in the "N" cells, as I have many
worksheets that I'm analyzing data in and I'd like to just copy and paste
the formulas from the N column and not have to figure out where the
sub-chunks of data are located.

Thanks
-Brian