counif greater or less than

Posted to microsoft.public.excel.worksheet.functions

Raza

Posts: n/a

counif greater or less than

This is my current countif statement:

=COUNTIF(J3:J33,"<-10")

BUT, I want to count anytime the cells are 10 or greater positive or negative.

Please help!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Matching Values from an Array	Mal	Excel Worksheet Functions	2	January 4th 06 10:06 AM
I want the greater number of 2 cells to show in a separate cell	cfiser	Excel Discussion (Misc queries)	2	November 16th 05 10:32 PM
I want the greater number of 2 cells to show in a separate cel	cfiser	Excel Discussion (Misc queries)	0	November 16th 05 10:03 PM
I want the greater number of 2 cells to show in a separate cell	Ron Coderre	Excel Discussion (Misc queries)	1	November 16th 05 09:22 PM
if greater then 99 then 1 if greater then 199 then two	N.R.	Excel Worksheet Functions	2	June 23rd 05 06:14 PM

All times are GMT +1. The time now is 05:00 AM.

Menu

About Us