Is there anyway to automatically update a spreadsheet when my client
updates a different spreadsheet (within the same workbook) and on the
same network.

I need to have a COUNT function to add up the total number of comments.
But these comments are long strings and the count function doesnt work.
Anyone have any suggestions. I figure I could use a macro but I have no
idea how to use them. So any guidance would be greatly appreciated.
Thanks.
Paul


--
pscoln1
------------------------------------------------------------------------
pscoln1's Profile: http://www.excelforum.com/member.php...o&userid=36702
View this thread: http://www.excelforum.com/showthread...hreadid=564812

hi u can try a countif function

=COUNTIF(D1721,"<>")

"<>" will count the cells that are not empty.

thanks

--
ernestgo
-----------------------------------------------------------------------
ernestgoh's Profile: http://www.excelforum.com/member.php...fo&userid=2487
View this thread: http://www.excelforum.com/showthread.php?threadid=56481

ernestgoh wrote:
> hi u can try a countif function
>
> =COUNTIF(D1721,"<>")
>
> "<>" will count the cells that are not empty.
>
> thanks.
>
>

Erm, the above function will count the number of cells containing <>.
Not what the OP asked for. It should read:

=COUNTIF(D1721,"<>""")

Or an easier way of counting cells that aren't empty would be:

=COUNTA(D1721)

As the purpose of COUNTA is to count non-empty cells, no condition is
required. Whereas, the COUNT formula requires the <>"" which checks that
the cell is not equal to an empty string "". Although, as this condition
itself has to be in inverted commas, you end up with the clunky "<>"""

HTH,

Jay