# A formula template

1. ## A formula template

hi.

I have a very interesting problem here and its solution, if possible, culd be very beneficial.

ok the question is like this. i have a spread sheet which u can consider to be that of Classes in a center. So i have different batches and diff no. of students in different batches. AT the bottom of each batch i take the total of each column, based on certain conditions, month wise. Different batches months coincide on the same sheet so that the totals for all batches for any month all fall in one column at various rows.

This formula for totals is same for all batches except that it works on a different range for various batches in the same column (for any one month). If there are 25 batches in a sheet, then every time i feel i need to modify this formula, i need to make changes at all those 25 places.

What i want to know and do is this.
Is it possible for me to create a formula template in some cell. The take that formula from there to all the various 25 places in the sheet. Find a dynamic way to calculate the range for each of those 25 batches which is automatically lifted by this formula and the results calculated. This would be tremendously beneficial because the next time i need to make some modification in the formula, i would be able to modify it at just one place and all changes would be accomplished automatically.

the formula template shud be sth like this (the formula itself is not important, it cud be anything). (if(iscount(RANGE),"",if(......) that i may place in just one cell. then place this formula at the various places reqd. and the RANGE be dynamically calculated (or Lifted) from a given cell against each Batch. If i insert or delete rows the RANGE shud be automatically modified as well.

i do have a my excel file but i am not able to upload it as its size exceeds 100kb, which is the limit to upload the xls file on this forum. Any help on that as well ?

I hope i have been able to express myself well enuff for u to understand the problem. Hope to get a reply to this very interesting and very useful problem.

Thanks All & have a great day,
Ajay.  Register To Reply

2. what size when zipped?  Register To Reply

3. ## Ok here's my zipped file, thanks mr. martin

pls find attaehed the zip xls file i am using for my example. Thanks to a tip from mr. martin.  Register To Reply

4. ## Re: A formula template

Hi

Did you solve the problem. I would like to know the solution!

Lars  Register To Reply

5. ## Re: A formula template

idamkjar,

This thread is over 4 yrs old and not likely to get a reply. Why dont you post your question in a new thread? You will surely receive faster responses that way.  Register To Reply

6. ## Re: A formula template

You are probably right :-)  Register To Reply