Thread: Count if data falls within a range AND that has a certain criteria
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default Count if data falls within a range AND that has a certain criteria
Hi,

Am Fri, 27 Apr 2012 03:33:26 +0000 schrieb LaVitaEBella:

A B
1 Yes
2 No
3 Yes
14 Yes
16 Yes
18 Yes
19 Yes

try:
=SUMPRODUCT(--(A1:A1000),--(A1:A100<=10),--(B1:B100="Yes"))


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
Reply With QuoteReply With Quote