formula error

[Raman]

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel =COUNTIF(DIARY!$I$2:$I$3068,1)
The above formula does not automatically update to increase the range of cells as new data is being added to sheet diary. How do I correct this. Also the sheet has over 200 items. Do I have to correct the formula for each cell or is it possible to correct the range in all at one go?
Thanks

 

[John McGhie]

You need to format the range as either a List or a Dynamic Range.

A List is simpler. See the Excel Help topic "Create a list".

For Dynamic Ranges, see here:
http://www.ozgrid.com/Excel/DynamicRanges.htm

And here:
http://www.ozgrid.com/forum/showthread.php?t=26826

Hope this helps

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel
=COUNTIF(DIARY!$I$2:$I$3068,1)
The above formula does not automatically update to increase the range of cells
as new data is being added to sheet diary. How do I correct this. Also the
sheet has over 200 items. Do I have to correct the formula for each cell or is
it possible to correct the range in all at one go?
Thanks

This email is my business email -- Please do not email me about forum
matters unless you intend to pay!