COUNTIF

[Pyrite]

I want to count a range of cells to see how do not contain a certain value.

Basically, I want to count how many cells in range A1 to A5 do not contain
#######.

I have tried loadsa things but have got myself tied in knots with trying to
reverse the operators etc.

 

[Mike H]

Hi,

What is #######?

Is it text or because the cell is too narrow?

Mike

 

[Pyrite]

It says that this is what is displayed when a time or date is negative. My
problem is that (see my post further down titled Formula Difficulty) I am
making a time sheet. On a daily basis the hours worked need to be added,
working to certain guidlines re overtime etc. I have got that working so it
is split correctly between standard rate and overtime rate. My problem is
that to add the time properly as in multiples of hours not actual time, so I
could have 40:00 for instance means that when the formula is copied and the
start and finish time cells that it references are empty (i.e. user hasnt
completed them yet) it displays #######. Really I need it to not display
this, an IF(ISERROR gets rid of it but it also then wont display the time
when times have been entered. Thats probably about as clear as mud (

This creates a further problem as if days are not worked then they remain
blank and so the ####### appears, this means then that the SUM function at
the bottom of the page wont work.