Biff

Posts: n/a

You're welcome.

Biff

"Stephen" wrote in message
...
That worked!
Thanks!
--
Thanks!

Stephen

"Biff" wrote:

Hi!

Try this:

=COUNTIF(A1:A10,"<"&A11)

Biff

"Stephen" wrote in message
...
Hi.

I'm trying to do an easy countif formula but it's not working. I want
to
count how many of the cells in a given range are less than another
specific
cell.

I used:

=COUNT(A1:A10,"<A11")

Why won't this work?
--
Thanks!

Stephen

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
Easy formula, but need help please	TxJprs	Excel Worksheet Functions	4	August 1st 05 05:52 PM
Countif formula and then some...	Julie	Excel Worksheet Functions	6	July 27th 05 08:13 PM
Easy formula question	BabyBlueAXiD	Excel Worksheet Functions	2	July 6th 05 10:26 PM
Easy formula Question	Excel formula fix	Excel Worksheet Functions	3	March 29th 05 02:04 AM
IF & VLOOKUP FORMULA	taxmom	Excel Worksheet Functions	3	March 2nd 05 03:35 PM

All times are GMT +1. The time now is 05:28 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us