Posted to microsoft.public.excel.misc

Help with Check Mark!! Help with Check Mark!! is offline

external usenet poster

Posts: 1

Greater than Less than formula

I have data in cells B6 through B31. In B32 I need to know the count of
B6:B31 that are greater than 50 but less than 100. In B33 I need to know the
count of B6:B31 that are greater than 40 but less than 49. In B34 I need to
know the count of B6:B31 that are greater than 30 but less than 39. etc. How?

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
writing a greater than/less than formula	BobVA	Excel Worksheet Functions	8	January 30th 09 08:40 PM
formula to workout equal to or greater than	wheelie	Excel Worksheet Functions	1	April 1st 06 01:09 PM
Greater than formula!	nekteo	Excel Worksheet Functions	2	December 29th 05 05:09 PM
Formula which is greater tahn or equal to zero	bruce2444	Excel Worksheet Functions	2	September 7th 05 12:24 PM
Formula checking multiple worksheets	sonic-the-mouse	Excel Worksheet Functions	2	June 5th 05 07:48 PM

All times are GMT +1. The time now is 10:25 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us