Hi
I have a range of cells that could contain numbers (from d11 to
ac11), if and countif function in the next cell to count the numbers
meeting the criteria. This range could be blank (empty cell).
The function returns 0 number if they meet the criteria or they are
blank.
The zero could be because of the criteria or because the cells are
empty.
I want to write this in the next cell but it does not work:
=IF(AND(D11:AD11="";AE11=0);"notpass";IF(AND(0AE1 1<=3);"pass";IF(OR(ISNUMBER(D11:AD11);AE11=0);"fin e";"")))
Why this because some ranges can be blanks, and some ranges could have
numbers but not in all the cells.
Thanks in Advance
Jam

OK, A few things we can talk about here.

1) 0AE11<=3 doesn't work in Excel. AND(0AE11,AE11<=3) is the corrected
version.

2) need to use , not ; to separate your criteria.

3)Using the ISNUMBER will return TRUE only if all values are numbers. Not
sure if you wanted that.

" wrote:

Hi
I have a range of cells that could contain numbers (from d11 to
ac11), if and countif function in the next cell to count the numbers
meeting the criteria. This range could be blank (empty cell).
The function returns 0 number if they meet the criteria or they are
blank.
The zero could be because of the criteria or because the cells are
empty.
I want to write this in the next cell but it does not work:
=IF(AND(D11:AD11="";AE11=0);"notpass";IF(AND(0AE1 1<=3);"pass";IF(OR(ISNUMBER(D11:AD11);AE11=0);"fin e";"")))
Why this because some ranges can be blanks, and some ranges could have
numbers but not in all the cells.
Thanks in Advance
Jam

Sean's point 2 may not be valid in this case. Some regional settings use a
semi-colon as a list separator, particularly if a comma is used as a decimal
point.
--
David Biddulph

"Sean Timmons" wrote in message
...
OK, A few things we can talk about here.

1) 0AE11<=3 doesn't work in Excel. AND(0AE11,AE11<=3) is the corrected
version.

2) need to use , not ; to separate your criteria.

3)Using the ISNUMBER will return TRUE only if all values are numbers. Not
sure if you wanted that.

" wrote:

Hi
I have a range of cells that could contain numbers (from d11 to
ac11), if and countif function in the next cell to count the numbers
meeting the criteria. This range could be blank (empty cell).
The function returns 0 number if they meet the criteria or they are
blank.
The zero could be because of the criteria or because the cells are
empty.
I want to write this in the next cell but it does not work:
=IF(AND(D11:AD11="";AE11=0);"notpass";IF(AND(0AE1 1<=3);"pass";IF(OR(ISNUMBER(D11:AD11);AE11=0);"fin e";"")))
Why this because some ranges can be blanks, and some ranges could have
numbers but not in all the cells.
Thanks in Advance
Jam

I am too obviously American. :-)

"David Biddulph" wrote:

Sean's point 2 may not be valid in this case. Some regional settings use a
semi-colon as a list separator, particularly if a comma is used as a decimal
point.
--
David Biddulph

"Sean Timmons" wrote in message
...
OK, A few things we can talk about here.

1) 0AE11<=3 doesn't work in Excel. AND(0AE11,AE11<=3) is the corrected
version.

2) need to use , not ; to separate your criteria.

3)Using the ISNUMBER will return TRUE only if all values are numbers. Not
sure if you wanted that.

" wrote:

Hi
I have a range of cells that could contain numbers (from d11 to
ac11), if and countif function in the next cell to count the numbers
meeting the criteria. This range could be blank (empty cell).
The function returns 0 number if they meet the criteria or they are
blank.
The zero could be because of the criteria or because the cells are
empty.
I want to write this in the next cell but it does not work:
=IF(AND(D11:AD11="";AE11=0);"notpass";IF(AND(0AE1 1<=3);"pass";IF(OR(ISNUMBER(D11:AD11);AE11=0);"fin e";"")))
Why this because some ranges can be blanks, and some ranges could have
numbers but not in all the cells.
Thanks in Advance
Jam