I am trying to test and count non-contiguous cells in form our HR department
made. There are to be numerical values entered in these cells, but not
every cell. I figured I could use CountIf, but I'm a little rusty on Excel.
Something like: =CountIf([Referenced Cells], AND(0, ,6)) but I keep getting
an error. Any help would be appreciated.

Thanks

Paul

I probably wasn't clear, I want to return a count of the number of cells
that meet that criteria.

"Paul" wrote in message
...
I am trying to test and count non-contiguous cells in form our HR
department made. There are to be numerical values entered in these cells,
but not every cell. I figured I could use CountIf, but I'm a little rusty
on Excel. Something like: =CountIf([Referenced Cells], AND(0, ,6)) but I
keep getting an error. Any help would be appreciated.

Thanks

Paul

Try this:

=SUM(COUNTIF(YourRange,{"0",6}))

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Paul" wrote:

I probably wasn't clear, I want to return a count of the number of cells
that meet that criteria.

"Paul" wrote in message
...
I am trying to test and count non-contiguous cells in form our HR
department made. There are to be numerical values entered in these cells,
but not every cell. I figured I could use CountIf, but I'm a little rusty
on Excel. Something like: =CountIf([Referenced Cells], AND(0, ,6)) but I
keep getting an error. Any help would be appreciated.

Thanks

Paul

I tried it but is returning 0. I need it to return the number of cells with
a value great than zero and less than 6. So if I have cells in my range
with 1, 3, 5, 7, 4, the formula should return 4.

"Ron Coderre" wrote in message
...
Try this:

=SUM(COUNTIF(YourRange,{"0",6}))

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Paul" wrote:

I probably wasn't clear, I want to return a count of the number of cells
that meet that criteria.

"Paul" wrote in message
...
I am trying to test and count non-contiguous cells in form our HR
department made. There are to be numerical values entered in these
cells,
but not every cell. I figured I could use CountIf, but I'm a little
rusty
on Excel. Something like: =CountIf([Referenced Cells], AND(0, ,6)) but
I
keep getting an error. Any help would be appreciated.

Thanks

Paul

Sorry.....I couldn't determine those criteria from your post.

Try something like this:
=COUNTIF(YourRange,"0")-COUNTIF(YourRange,"=6")

Or...if you feel like something fancier:
=SUM(COUNTIF(YourRange,{"0","=6"})*{1,-1})

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Paul" wrote:

I tried it but is returning 0. I need it to return the number of cells with
a value great than zero and less than 6. So if I have cells in my range
with 1, 3, 5, 7, 4, the formula should return 4.

"Ron Coderre" wrote in message
...
Try this:

=SUM(COUNTIF(YourRange,{"0",6}))

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Paul" wrote:

I probably wasn't clear, I want to return a count of the number of cells
that meet that criteria.

"Paul" wrote in message
...
I am trying to test and count non-contiguous cells in form our HR
department made. There are to be numerical values entered in these
cells,
but not every cell. I figured I could use CountIf, but I'm a little
rusty
on Excel. Something like: =CountIf([Referenced Cells], AND(0, ,6)) but
I
keep getting an error. Any help would be appreciated.

Thanks

Paul

Thank you, it worked.


"Ron Coderre" wrote in message
...
Sorry.....I couldn't determine those criteria from your post.

Try something like this:
=COUNTIF(YourRange,"0")-COUNTIF(YourRange,"=6")

Or...if you feel like something fancier:
=SUM(COUNTIF(YourRange,{"0","=6"})*{1,-1})

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Paul" wrote:

I tried it but is returning 0. I need it to return the number of cells
with
a value great than zero and less than 6. So if I have cells in my range
with 1, 3, 5, 7, 4, the formula should return 4.

"Ron Coderre" wrote in message
...
Try this:

=SUM(COUNTIF(YourRange,{"0",6}))

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Paul" wrote:

I probably wasn't clear, I want to return a count of the number of
cells
that meet that criteria.

"Paul" wrote in message
...
I am trying to test and count non-contiguous cells in form our HR
department made. There are to be numerical values entered in these
cells,
but not every cell. I figured I could use CountIf, but I'm a little
rusty
on Excel. Something like: =CountIf([Referenced Cells], AND(0, ,6))
but
I
keep getting an error. Any help would be appreciated.

Thanks

Paul

Thanks for the update, Paul

***********
Regards,
Ron

XL2002, WinXP


"Paul" wrote:

Thank you, it worked.


"Ron Coderre" wrote in message
...
Sorry.....I couldn't determine those criteria from your post.

Try something like this:
=COUNTIF(YourRange,"0")-COUNTIF(YourRange,"=6")

Or...if you feel like something fancier:
=SUM(COUNTIF(YourRange,{"0","=6"})*{1,-1})

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Paul" wrote:

I tried it but is returning 0. I need it to return the number of cells
with
a value great than zero and less than 6. So if I have cells in my range
with 1, 3, 5, 7, 4, the formula should return 4.

"Ron Coderre" wrote in message
...
Try this:

=SUM(COUNTIF(YourRange,{"0",6}))

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Paul" wrote:

I probably wasn't clear, I want to return a count of the number of
cells
that meet that criteria.

"Paul" wrote in message
...
I am trying to test and count non-contiguous cells in form our HR
department made. There are to be numerical values entered in these
cells,
but not every cell. I figured I could use CountIf, but I'm a little
rusty
on Excel. Something like: =CountIf([Referenced Cells], AND(0, ,6))
but
I
keep getting an error. Any help would be appreciated.

Thanks

Paul