Posted to microsoft.public.excel.misc

external usenet poster

Posts: 10

Combining COUNTIF and AND functions

Hello,
I want a row counted only if the row contains the letters "AA" in one cell
and does not contain the letters "NOT REQ'D" in another cell of the same row.

The COUNTIF statement works fine. =COUNTIF(A4:A1000,"AA")

However, I tried adding the AND statement but can't get it to work.

Would someone be able to help please?
Merci,
KA

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
combining IF, AND, and OR Functions	Hillary: needing some help[_2_]	Excel Worksheet Functions	5	October 9th 08 04:37 PM
Combining Functions	MikeM	Excel Discussion (Misc queries)	3	September 30th 08 04:52 PM
Combining IF & AND functions	Khoshravan	Excel Discussion (Misc queries)	5	October 3rd 07 12:12 AM
Combining LOOKUP and COUNTIF functions	kate_suzanne	Excel Worksheet Functions	2	August 22nd 06 06:59 AM
Combining COUNTIF and AND functions	david	Excel Worksheet Functions	16	July 7th 06 02:55 AM

All times are GMT +1. The time now is 05:46 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us