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