View Single Post
  #5   Report Post  
CLR
 
Posts: n/a
Default

One way would be to CONCATENATE the two columns together into a helper
column and then do a simple COUNTIF on that helper column for the
combination desired..........

Vaya con Dios,
Chuck, CABGx3



"N E Body" wrote in message
...
Hi everyone

I can use Countif to count the number of "Pass" in column AV however I

only
want to count "Pass" in column AV if Am (same row) = "High"
I tried =Countif(AM:AM,"High")AND,Countif(AV:AV,"Pass") but that did not
work!

Any suggestions

Kenny