Basic Excel help for beinnger

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

pscoln1 - 25 Jul 2006 18:10 GMT

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

Signature

pscoln1

Reply to this Message

ernestgoh - 25 Jul 2006 18:38 GMT

hi u can try a countif function

=COUNTIF(D17:D21,"<>")

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

thanks

Reply to this Message

Jay - 29 Jul 2006 14:38 GMT

> hi u can try a countif function
>
[quoted text clipped - 3 lines]
>
> thanks.

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

=COUNTIF(D17:D21,"<>""")

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

=COUNTA(D17:D21)

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

Reply to this Message

Rate this thread: