Posted to microsoft.public.excel.worksheet.functions

Keith[_3_] Keith[_3_] is offline

external usenet poster

Posts: 10

Countif query

Take 2 - I don't think my first request got sent.

I am attempting to count the number of cells in AB2:AB26 that have a number
less thn zero. I have attempted this formula without success:

=COUNTIF(AB2:AB26,<0)

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
Mutliple Function Query - probably using Countif	Damo	Excel Worksheet Functions	2	May 13th 09 06:40 PM
COUNTIF function query	Wendy-Bob[_2_]	Excel Worksheet Functions	6	January 21st 09 03:05 PM
Excel 2007 / MS Query - editing existing query to another sheet	Hotpepperz	Excel Discussion (Misc queries)	0	June 13th 08 06:53 PM
Countif Query	John Moore	Excel Discussion (Misc queries)	4	June 25th 07 10:06 PM
COUNTIF function query for multiple colums	Malcolm Gordon	Excel Worksheet Functions	5	April 10th 06 08:10 AM

All times are GMT +1. The time now is 02:06 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us