Excel problem :\

cstX · Dec 26, 2009, 01:20 PM

Hello guys. I just started playing around with excel and for the most part its not too hard but i have hit a wall here and cant seem to figure it out or find the answer anywhere on the net..

What i need sounds simple enough i guess for someone experienced with excel. I need a formula that would list throught a column and return the number of values higher or equal to 1000.

Anyone have any idea how this can be done ?

cstX · Dec 26, 2009, 02:29 PM

I have tried something out :\ going crazy any minute now..

=COUNTIF(D6

20,"" >= 1000) returns 0 for some reason and there are 8 cells in that range that are higher than 1000 :\

=COUNTA(D6

20,"" >= 1000) on the other hand returns 16 :| and thats not right since there are only 15 numbers total in that range 8 of which are higher than 1000

EDIT: Solved!

Excel it self is to blame for suggesting an incorrect fix to ">=1000 .. instead of ">=1000" it suggested "">1000 for some reason :\

Sihastru · Dec 29, 2009, 06:16 PM

Make sure all cells contain numerical values, maybe it gets sidetracked by conversions.

Dec 26, 2009, 01:20 PM	#1
cstX HardwareHeaven Junior Member Join Date: Jan 2009 Location: Serbia Posts: 52 Rep Power: 0 System Specs	Excel problem :\ Hello guys. I just started playing around with excel and for the most part its not too hard but i have hit a wall here and cant seem to figure it out or find the answer anywhere on the net.. What i need sounds simple enough i guess for someone experienced with excel. I need a formula that would list throught a column and return the number of values higher or equal to 1000. Anyone have any idea how this can be done ? __________________ Nothing real can be threatened. Nothing unreal exists. email archiving

Dec 26, 2009, 02:29 PM	Thread Starter #2
cstX HardwareHeaven Junior Member Join Date: Jan 2009 Location: Serbia Posts: 52 Rep Power: 0 System Specs	Re: Excel problem :\ I have tried something out :\ going crazy any minute now.. =COUNTIF(D620,"" >= 1000) returns 0 for some reason and there are 8 cells in that range that are higher than 1000 :\ =COUNTA(D620,"" >= 1000) on the other hand returns 16 :\| and thats not right since there are only 15 numbers total in that range 8 of which are higher than 1000 EDIT: Solved! Excel it self is to blame for suggesting an incorrect fix to ">=1000 .. instead of ">=1000" it suggested "">1000 for some reason :\ __________________ Nothing real can be threatened. Nothing unreal exists. email archiving Last edited by cstX; Dec 26, 2009 at 03:23 PM.

Dec 29, 2009, 06:16 PM	#3
Sihastru Never been clicked Join Date: Dec 2009 Posts: 433 Rep Power: 46 System Specs	Re: Excel problem :\ Make sure all cells contain numerical values, maybe it gets sidetracked by conversions.