COPYING FORMULAS
It is most likely due to the fact that you are using relative references...
When you copy your formula down
B2:B112 will change to B3:B113 and so on... Is that what you want?
If you want B2:B112 in all cells then use $B$2:$B$112
Other vairation -
B$2:B$112 which will change to C$2:C$112 if copied to the right
"Etg-Para" wrote:
Here is my formula:
=IF(AND(2001DATAB2:B112=€ťGerson, Eileen T.€ť,2001 DATAD2:D112=€ťGeneral
Fees€ť),SUM(2001 DATAG2:G112),€ť$ -€ś).
This formula does work but I need to copy it into spreadsheets for several
people and for several categories, and finally for several years.
When I copied the formula and changed the named criteria, ie., Gerson,
Eileen T. and General Fees, it worked fine for the first few people, but then
on about the fifth one, when I copied the information, it copied fine, but
when I changed the criteria, it erred with the following:
#VALUE!
Am I missing something on the copying feature?
Thank you.
|