Thread: COUNTIF 2 Conditions using Defined Names
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Paul Dennis
 
Posts: n/a
Default COUNTIF 2 Conditions using Defined Names
SLA_GROUP is a defined name for a COL A
NO_ROLL_NUM is a defined name for COL B

COUNTIF(SLA_GROUP,$C5) works but I'm trying to COUNTIF based on SLA_GROUP =
C% and also were NO_ROLL_NUM = 11.

any ideas?
Reply With QuoteReply With Quote