Posted to microsoft.public.excel.worksheet.functions

John Michl

Posts: n/a

countif functions

Try
=SUMPRODUCT((A1:A10=10)*(A1:A10<=20))

For info on sumproduct see
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

- John
www.JohnMichl.com

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
combined two countif functions	Geoff	Excel Discussion (Misc queries)	2	August 11th 05 11:51 PM
Multiple Functions IF, AND, COUNTIF, MATCH	Mike	Excel Worksheet Functions	3	July 29th 05 08:03 PM
COUNTIF and Nested Functions?	Larry Novida	Excel Worksheet Functions	3	May 29th 05 07:05 PM
COUNTIF functions	danowynn	Excel Worksheet Functions	4	May 4th 05 10:28 PM
How do I combine COUNTIF and AND functions in Excel	J Roney	Excel Worksheet Functions	2	February 15th 05 08:41 PM

All times are GMT +1. The time now is 05:02 AM.

About Us

"It's about Microsoft Excel"