Thread: Count if with multiple column criteria
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
  
Posts: 9,221
Default 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

Reply With QuoteReply With Quote