Couting rows with multiple criteria

**onder** · 10-02-2012, 04:34 AM

Hello all,

I have a small problem,l hopefully you can help me.

I am trying to calculate rows where 2 or several cells contains specific text1 or text 2, etc.

Can you help me with?

Thank you.

**zbor** · 10-02-2012, 04:41 AM

Can you upload example workbook?

**Kevin UK** · 10-02-2012, 04:47 AM

Hi

Maybe

Formula:

Please Login or Register  to view this content.

CTR + SHIFT + ENTER

**twiggywales** · 10-02-2012, 04:50 AM

probably a sumproduct function will work if you upload a book will be easier to tell

**onder** · 10-02-2012, 04:59 AM

example.jpg

Picture uploaded.

Basically I would like to match criteria if cell in row 2 contains FTS and 09 than the outcame is TRUE, etc.

**Ace_XL** · 10-02-2012, 05:06 AM

=AND(ISNUMBER(SEARCH("FTS",A1)),YEAR(B1)=2009)

copy down

**onder** · 10-02-2012, 05:13 AM

=AND(ISNUMBER(SEARCH("FTS",A1)),YEAR(B1)=2009) is not working, formula errors.

Error: "FTS",A1. Even I interchanged it to "FTS";A1, another error is ",YEAR".