Posted to microsoft.public.excel.misc

readystate readystate is offline

external usenet poster

Posts: 25

Count using multuple criteria

I have a spreadsheet where column B is a drop down box with two choices - NEW
or EXISTING. I need to count the number of times that the word NEW appears
in column B if column J is equal to specific criteria, ex, CLOSED. Please
help me with this formula. Thanks.

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
Criteria count	Gaetan	Excel Discussion (Misc queries)	7	June 4th 07 01:44 PM
count using criteria	ferde	Excel Discussion (Misc queries)	4	March 21st 07 04:01 PM
How to count nos. on 3 criteria	Excel_Learner	Excel Worksheet Functions	5	August 28th 06 03:17 PM
Count If 3 Criteria Met	kieffer	Excel Worksheet Functions	9	April 15th 06 12:38 AM
Sum Count of Criteria Every 3rd Row	Sam via OfficeKB.com	Excel Worksheet Functions	5	December 11th 05 02:21 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us