Have received your email - will get back to you tomorrow (bit late
here).

Pete

On May 5, 1:46*am, BrettPotts
wrote:
I have a spreadsheet with some cells which are shaded cells and some that
have values in them. On each row i would like a cell that will calculate the
number of coloured or shaded cells (excluding the cells with text or values
in them). What formula could i use and would the formula work if i needed to
calculate colums as well?