Posted to microsoft.public.excel.worksheet.functions

Jakobshavn Isbrae Jakobshavn Isbrae is offline

external usenet poster

Posts: 78

description of countif criteria?

Does a description exist in a book or website of valid countif criteria?
For example - =COUNTIF(A$7:A$15,2) works

=COUNTIF(A$7:A$15,"=2") also works, but
=COUNTIF(A$7:A$15,"=1+1") does not work

I don't need an answer to a specific example, just a place to go and read on
my own.

Thanks in advance for any help received.
--
jake

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
Two criteria for CountIf?	DB_Bill	Excel Worksheet Functions	6	June 1st 06 04:33 PM
More than 1 countif criteria	KristyBT	Excel Discussion (Misc queries)	2	May 2nd 06 11:55 PM
can countif function look at 2 separate columns for criteria	blake7	Excel Worksheet Functions	2	March 16th 06 08:07 PM
COUNTIF with two criteria	Boran Düzgün	Excel Worksheet Functions	3	March 7th 06 10:43 PM
Countif with star operator in criteria	[email protected]	Excel Worksheet Functions	7	November 1st 05 03:16 PM

All times are GMT +1. The time now is 06:41 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us