Testing Cells

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

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.
 
Try this:

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

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

XL2002, WinXP


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

Paul said:
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
Click to expand...
Click to expand...
 
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 said:
Try this:

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

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

XL2002, WinXP


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

Paul said:
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
Click to expand...
Click to expand...
Click to expand...
 
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 said:
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 said:
Try this:

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

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

XL2002, WinXP


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

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
Click to expand...
Click to expand...
Click to expand...
 
Thank you, it worked.


Ron Coderre said:
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 said:
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 said:
Try this:

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

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

XL2002, WinXP


:

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

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
Click to expand...
Click to expand...
Click to expand...
 
Thanks for the update, Paul

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

XL2002, WinXP


Paul said:
Thank you, it worked.


Ron Coderre said:
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 said:
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.

Try this:

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

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

XL2002, WinXP


:

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

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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top