'False

[Rob Sutton]

Hello,

I am trying to use the countifs function to return the number of instances that meet a particular set of conditions.


One condition is that a particular attribute be False.

=countifs('RA Inductions and Completions'!I:I, "=False")
=countifs('RA Inductions and Completions'!I:I, "='False")
=countifs('RA Inductions and Completions'!I:I, False)

I have tried all three of the above formulae, but all return 0, despite there being a large number of instances that are 'False'.

The actual colum contains items that are strings, not logical values, i.e. the data is: 'False not False.

How do I correctly reference these cells to count the number of instances that are False?

Thanks,

Rob.

 

[Rob Sutton]

Also, as an aside, is countifs the best method of counting the number of instances within a table that meet a given set of conditions?

My table is over 7000 lines long, and I have to ask a number of questions. For example, I want to get the number of items with priority = False, date delivered > 1 Feb 11, delay > 30 and date received is after 1 Nov 10.

I have used a series of countifs to do this, but my spreadsheet is now 25Mb in size...

Thanks,

Rob.

 

[Dryver14]

try using COUNTIF not COUNTIFS

 

[Rob Sutton]

Thanks Dryver - I tried that already. The problem is the same regardless. I am using the countifs function because there are multiple conditions I want to check for.

 

[Haseeb Avarakkan]

May be;

=COUNTIF(I:I,"*false*")

 

[Dryver14]

which version of excel are you using? i dont think 2003 and before support
countifs

 

[CWatts]

Just use a blank cell some where. So for this example, I'll use cell D5.

In that cell enter a false formula like =5=4.

5 does not equal 4, so therefore the value is false.

For your formula, just use =COUNTIF(I:I,D5) and that should work.

 

[Rob Sutton]

Thanks Haseeb: that worked, and I should have thought of that!

@Dryver14: I am using MS Excel 2007 SP2. Sorry, I should have included that in the original.

@CWatts: I tried to do that, but it didn't get me the results I need. In my column, ~6000 items are 'False and ~1000 are 'True, so I need to be able to distinguish between them. Using the *false works, although I am not sure why it didn't work the other way.

Thanks guys, for all your help.