Posted to microsoft.public.excel.misc

external usenet poster

Posts: 132

Count if - 2 conditions

Hi:

How would I write A "COUNT IF AND" formula? I tried

COUNT IF AND(E5:E30,"MAMA"),(B:5:C30,"4"), but there is an error somewhere.

Thanks in advance.
Escarly

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 on multiple conditions	Debbie	Excel Worksheet Functions	6	September 21st 06 06:34 PM
Count with 2 conditions, second one OR	[email protected]	Excel Worksheet Functions	2	June 4th 06 05:55 PM
How to count after 2 conditions are met	Dave Schwinger	Excel Worksheet Functions	3	April 3rd 06 09:29 PM
Count ifs - 2 conditions	Nick	Excel Discussion (Misc queries)	5	January 12th 06 05:06 PM
Count with 2 conditions?	Lee	Excel Worksheet Functions	2	March 19th 05 02:45 AM

All times are GMT +1. The time now is 09:22 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us