Count if with multiple column criteria

[JPS]

I have multiple columns in a spreadsheet and I need to count the number times
column D contains “TBN†when column L is equal to 1

Thanks.

 

[Max]

Maybe something like this in say, M2:
=SUMPRODUCT((D210="TBN")*(L2:L10=1))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,700 Files:359 Subscribers:55
xdemechanik

 

[JPS]

Max,
Works great when column D is only "TBN" how do I add criteria when D
conatins TBN-July or TBNamed

 

[Max]

This then, in M2:
=SUMPRODUCT((ISNUMBER(SEARCH("TBN",D210))*(L2:L10=1)))

Replace SEARCH with FIND if you need it to be a stricter, case sensitive
search
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,700 Files:359 Subscribers:55
xdemechanik

 

[Mike H]

Try

=SUMPRODUCT((LEFT(D210,3)="TBN")*(L2:L10=1))

Mike

 

[JPS]

Perfecto... Thanks
--
JPS

This then, in M2:
=SUMPRODUCT((ISNUMBER(SEARCH("TBN",D210))*(L2:L10=1)))

Replace SEARCH with FIND if you need it to be a stricter, case sensitive
search
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,700 Files:359 Subscribers:55
xdemechanik

 

[JPS]

Mike,
Worked... Thanks for the solution
--
JPS

Try

=SUMPRODUCT((LEFT(D210,3)="TBN")*(L2:L10=1))

Mike

 

[Max]

Perfecto... Thanks

Welcome. Take a moment to press the "Yes" button below
from where you're reading this.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,700 Files:359 Subscribers:55
xdemechanik
---