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
|