Previous Topic Next Topic

Counting

Solved/Closed
beejer - Feb 18, 2010 at 04:58 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 18, 2010 at 05:09 PM
Hello,
I am trying to count the number of cell's from I4:I304 that have "no access" in it, but in those cells not only do some of them have "no acces" but there is amother line in the cell therfore it won't read it unless "no access" is by it self. is there a way to count the no access if it is in the beginning of the cell even thou there are other words following it?
Thanks,
beejer

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 18, 2010 at 05:09 PM
to count when it start with "no access"
=COUNTIF(I4:I304, "no access*")

to count when it only contains "no access"
=COUNTIF(I4:I304, "no access")

to count when it contain some where "no access"
=COUNTIF(I4:I304, "*no access*")
1

Similar discussions

counting and stop counting days in a cell
diestra123 -
diestra123 -

4 responses
Counting cells containing only numbers
jutulu -
jutulu -

4 responses
Start and stop counting at the zero value
Naima -
TrowaD -

5 responses
Counting number of times a value appears if..
jensorr -
sambr22 -

7 responses
mysql - Counting number of occurrences of value in multiple columns
BrianGreen -
dragontattoo -

19 responses