COUNTIF

P

Paul

I need a formula to count the # of rows where the contents
of Cell A2 are in column I and column E contains "S".
 
P

Peo Sjoblom

=SUMPRODUCT((I2:I100=A2)*(E2:E100="S"))

or

=SUMPRODUCT((I2:I100=A2)*(ISNUMBER(SEARCH("S",E2:E100))))

if can be part of a string. It is probably the first one you are looking
for
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

countifs Function not giving desired result with date criteria 2
Using <= in countifs statement 1
Count Number of Unique Cells That Don't Have Certain Characters 0
Excel - Wich Function should I use? 1
Excel 2010 countifs for date range 3
Remove Identical words 0
Trying to count based on multiple criteria & cell comparisons 4
Countif or other formula needed for multiple data/critera results 3

Top