JoatNIC

Posts: n/a

Countif Multiple Criteria

I need to count the number of cells in Column A that contain an S, AND the
cells in Column B that contain an E. So, if there are a total of 6 rows,
and 4 contain an S and 3 Contain an E the answer should be 3.

Do I use COUNTIF OR SUMPRODUCT?

What will the formula/function look like?

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
Countif w/ Multiple Criteria	Patrick_KC	Excel Worksheet Functions	2	August 9th 05 09:25 PM
Countif for multiple criteria	Jim Rennie	Excel Worksheet Functions	3	June 21st 05 01:38 AM
COUNTIF or SUMPRODUCT counting multiple criteria	Peo Sjoblom	Excel Worksheet Functions	0	May 31st 05 11:40 PM
Countif formula with multiple criteria ie >30 and <60?	Dali	Excel Worksheet Functions	2	January 7th 05 04:49 PM
Countif with multiple criteria and multiple worksheets	JJ	Excel Worksheet Functions	1	December 28th 04 06:37 PM

All times are GMT +1. The time now is 11:37 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us