John Higgins

Posts: n/a

COUNTIF MEETING TWO CRITERIA eg>5 AND <10.1

I have a range of values. I wish to count the number of values in this row
that are between 5 and 10.1.

How do I do this?

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
countif, dinamic criteria	Stan Altshuller	Excel Worksheet Functions	2	December 8th 04 08:22 PM
Countif - Countif	maswinney	Excel Worksheet Functions	3	November 15th 04 11:06 PM
How do I get the COUNTIF criteria to recognize only month and yea.	Omega	Excel Worksheet Functions	4	November 6th 04 07:22 AM
Can I use a cell reference in the criteria for the sumif function.	Number Cruncher	Excel Worksheet Functions	2	November 4th 04 07:52 PM
countif, again	Liz G	Excel Worksheet Functions	2	November 1st 04 11:20 PM

All times are GMT +1. The time now is 03:59 AM.

About Us

"It's about Microsoft Excel"