Posted to microsoft.public.excel.misc

Sung

external usenet poster

Posts: 9

Count question

What is the formula to count from a column based on multiple criteria.

For example,

City

Los Angeles
Phoenix
Los Angeles
New York
Chicago
New York

so i would like a formula to return the total count of new york and los
angeles. In this example it would be 4.

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
Count and Count if funtions	Debi	Excel Worksheet Functions	3	September 27th 05 08:41 PM
Count Question	inkpassion	Excel Discussion (Misc queries)	1	September 13th 05 12:05 AM
complex count question	JBoulton	Excel Worksheet Functions	13	March 24th 05 02:57 AM
Pivot Tables - "simple" question	Eoin Bairead	Excel Discussion (Misc queries)	1	February 28th 05 07:07 PM
Conversion	SVC	Excel Worksheet Functions	9	February 28th 05 02:29 PM

All times are GMT +1. The time now is 01:29 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us