Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
countif | Excel Discussion (Misc queries) | |||
How do I use a countif function according to two other countif fu. | Excel Worksheet Functions | |||
edit this =COUNTIF(A1:F16,"*1-2*")+COUNTIF(A1:F16,"*2-1*") | Excel Discussion (Misc queries) | |||
COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
COUNTIF in one colum then COUNTIF in another...??? | Excel Worksheet Functions |