COUNTIF
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. |
COUNTIF
Hi,
What is #######? Is it text or because the cell is too narrow? Mike "Pyrite" wrote: 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. |
COUNTIF
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 :o( 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. "Mike H" wrote: Hi, What is #######? Is it text or because the cell is too narrow? Mike "Pyrite" wrote: 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. |
All times are GMT +1. The time now is 09:53 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com