COUNTIF
 

Hi,
I need to count the number of FALSE values returned in another worksheet
based on 'and' function in that column. I am using the following function:
=COUNTIF('Main Entry Sheet'!A26:A463,"'Main Entry Sheet'!AN26:AN463=FALSE")
but I get a 0 value returned as "=and........" is the true value of the
cells rather than the returned "TRUE/FALSE"

Please help

COUNTIF
 

Unclear.
You want to count the cells in A26:A463 based on the condition that the
corresponding cell in AN26:AN463 has FALSE value? It would seem that the
answer will be exactly the same as counting the number of FALSE values in
the second range.
Unless you mean: count the cells with numeric values in range-1 when
corresponding cells in range-2 = FALSE
With numbers and text in A1:A10 and TRUE/FALSE in B1"B10, this gives the
correct count
=SUMPRODUCT(--(ISNUMBER(A1:A10)),--NOT(B1:B10))
Any help?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email


"Giulia" wrote in message
...
Hi,
I need to count the number of FALSE values returned in another worksheet
based on 'and' function in that column. I am using the following
function:
=COUNTIF('Main Entry Sheet'!A26:A463,"'Main Entry
Sheet'!AN26:AN463=FALSE")
but I get a 0 value returned as "=and........" is the true value of the
cells rather than the returned "TRUE/FALSE"

Please help

COUNTIF
 

Sorry if unclear ! I may have false values in column AN where there is no
number in Column A. I need to Count the number in A only when there is a
false value in AN.
I only have numbers in A

"Bernard Liengme" wrote:

Unclear.
You want to count the cells in A26:A463 based on the condition that the
corresponding cell in AN26:AN463 has FALSE value? It would seem that the
answer will be exactly the same as counting the number of FALSE values in
the second range.
Unless you mean: count the cells with numeric values in range-1 when
corresponding cells in range-2 = FALSE
With numbers and text in A1:A10 and TRUE/FALSE in B1"B10, this gives the
correct count
=SUMPRODUCT(--(ISNUMBER(A1:A10)),--NOT(B1:B10))
Any help?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email


"Giulia" wrote in message
...
Hi,
I need to count the number of FALSE values returned in another worksheet
based on 'and' function in that column. I am using the following
function:
=COUNTIF('Main Entry Sheet'!A26:A463,"'Main Entry
Sheet'!AN26:AN463=FALSE")
but I get a 0 value returned as "=and........" is the true value of the
cells rather than the returned "TRUE/FALSE"

Please help

COUNTIF
 

My SUMPRODUCT formula is what you need
Just change the A1:A10 and B1:B10 to fit your ranges
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Giulia" wrote in message
...
Sorry if unclear ! I may have false values in column AN where there is no
number in Column A. I need to Count the number in A only when there is a
false value in AN.
I only have numbers in A

"Bernard Liengme" wrote:

Unclear.
You want to count the cells in A26:A463 based on the condition that the
corresponding cell in AN26:AN463 has FALSE value? It would seem that the
answer will be exactly the same as counting the number of FALSE values in
the second range.
Unless you mean: count the cells with numeric values in range-1 when
corresponding cells in range-2 = FALSE
With numbers and text in A1:A10 and TRUE/FALSE in B1"B10, this gives the
correct count
=SUMPRODUCT(--(ISNUMBER(A1:A10)),--NOT(B1:B10))
Any help?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email


"Giulia" wrote in message
...
Hi,
I need to count the number of FALSE values returned in another
worksheet
based on 'and' function in that column. I am using the following
function:
=COUNTIF('Main Entry Sheet'!A26:A463,"'Main Entry
Sheet'!AN26:AN463=FALSE")
but I get a 0 value returned as "=and........" is the true value of the
cells rather than the returned "TRUE/FALSE"

Please help