Help with formula to count number of FALSE statements in a column

[D_Spark]

Hi all,

Im having difficulty in trying to count the number of FALSE statement in a specific column.

My current formula is

=COUNTIF(latestvoda!Q2:Q1611,"FALSE")


however this returns zero, I have tried the "FALSE" with and without the quotation marks and still the value returned is zero.



the forumla in series Q2:Q1611 is:

=IF(D2=3.75,"TRUE",IF(D2=21,"TRUE",IF(D2=11.91,"TRUE",IF(D2=18,"TRUE","FALSE"))))
=IF(D3=3.75,"TRUE",IF(D3=21,"TRUE",IF(D3=11.91,"TRUE",IF(D3=18,"TRUE","FALSE"))))


etc

 

[brans1982]

Hi,

You can take the "" of TRUE and FALSE on your formula e.g...

=IF(D2=3.75,TRUE,IF(D2=21,TRUE,IF(D2=11.91,TRUE,IF(D2=18,TRUE,FALSE))))

then this formula should work...

=COUNTIF(latestvoda!Q2:Q1611,FALSE)

 

[D_Spark]

Sorry I tried this and still shows zero when Im expecting more than 1 to be returned across the series Q

 

[brans1982]

Sorry,

I'm not sure why it's working. Hoefully somebody else will figure it out.

By the way, you can use the OR function in your IF statement to shorten it e.g.

=IF(OR(D2=3.75,D2=21,D2=11.91,D2=18),TRUE,FALSE)

 

[sanrv1f]

First, you can shorten the formula in Q2:Q1611 to

=OR(D2={3.75,21,11.91,18})

then you can count the FALSE, with

=COUNTIF(Q2:Q1611,FALSE)

 

[D_Spark]

thanks folks your suggestions were greatly appreciated and matter now resolved !