Hi
I am using Excel XP version 2002. I have a database with 1000 different
farmer ID numbers, each with multiple rows of use rates for a chemical. I
would like to find the average use rate for each of these growers. I can
enter a formula: = DAVERAGE(database range, use rate column, criteria) But
the criteria part is the misery!I need to create 1000 criteria columns (colum
heading with each ID number) for each grower's ID #! I have tried one column
heading and all of the ID numbers below, but the average is then cummulative.
I would love to be able to create the formula, then copy and paste it down a
results row, supplying me with the average use rate for each grower, but the
criteria requires two cells (column name and criteria), and my pasted results
only a one cell difference. Is there any way to accomplish my goal of not
having to type out 1000 individual formulas? I hope this isnt too confusing -
it is hard to describe my problem without being able to show the excel sheet

Thanks in advance for any help or hints
-Kimberly