Count if with multiple column criteria
 

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.

--
JPS

Count if with multiple column criteria
 

Maybe something like this in say, M2:
=SUMPRODUCT((D2:D10="TBN")*(L2:L10=1))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,700 Files:359 Subscribers:55
xdemechanik
---
"JPS" wrote:
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

Count if with multiple column criteria
 

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


"Max" wrote:

Maybe something like this in say, M2:
=SUMPRODUCT((D2:D10="TBN")*(L2:L10=1))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,700 Files:359 Subscribers:55
xdemechanik
---
"JPS" wrote:
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

Count if with multiple column criteria
 

This then, in M2:
=SUMPRODUCT((ISNUMBER(SEARCH("TBN",D2:D10))*(L2:L1 0=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" wrote:
Max,
Works great when column D is only "TBN" how do I add criteria when D
contains TBN-July or TBNamed

Count if with multiple column criteria
 

Try

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

Mike

"JPS" wrote:

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


"Max" wrote:

Maybe something like this in say, M2:
=SUMPRODUCT((D2:D10="TBN")*(L2:L10=1))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,700 Files:359 Subscribers:55
xdemechanik
---
"JPS" wrote:
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

Count if with multiple column criteria
 

Perfecto... Thanks
--
JPS


"Max" wrote:

This then, in M2:
=SUMPRODUCT((ISNUMBER(SEARCH("TBN",D2:D10))*(L2:L1 0=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" wrote:
Max,
Works great when column D is only "TBN" how do I add criteria when D
contains TBN-July or TBNamed

Count if with multiple column criteria
 

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


"Mike H" wrote:

Try

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

Mike

"JPS" wrote:

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


"Max" wrote:

Maybe something like this in say, M2:
=SUMPRODUCT((D2:D10="TBN")*(L2:L10=1))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,700 Files:359 Subscribers:55
xdemechanik
---
"JPS" wrote:
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

Count if with multiple column criteria
 

"JPS" wrote:
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
---