Microsoft Excel - formula query - COUNTIF with two criteria

Australia
November 22, 2006 10:56pm CST
I am trying to create a function that Counts content in a cell if it meets two criteria. However I am having no luck doing so. Formula options tried (yet failed): =COUNTIF($A2:$BG$61,(BF70 AND(IF(LOOKUP($BF$69,$C$2:$C$64)),=$BF$69))) =COUNTIF((IF(LOOKUP($BF$69,$C$2:$C$64)=$BF$69)$A$2:$BG$61,BF70) Could someone please help me in what I must do to achieve my desired results. Cheers Fiona
No responses