I have a row of data that I would like to have "total" at the end of the row
in Column "T". The formula should count all of the non-blank cells in the
range C6 thru r6. I have been using numerous variations on the
=COUNTIF(C6:R6,"*") formula or COUNTA(c6:r6), etc. etc.. All will total the
non blank cells, HOWEVER, if a cell in the range is changed (updated), the
count does not automatically update in Column "T". How can I get it do to
this.

Example:
Col 1 Col2 Col3 Col4)
Row 1 X

COUNTA(c1:c4) gives me a count of 1
If I then add and "x" in Col 4, the count remains at 1, unless I enter the
formula again.

I just want to to automatically recalculate if the data in the range is
modified.

Please and THanks.



Col 5