Countif

[rudevincy]

I have a sheet that has a list....

I am trying to count the number of 1 in range AU2:AU1000 but only if the value in range AC2:AC1000 is equal to "WATSON"

would COUNTIFS((AU2:AU1000=1, AC2:AC1000 is equal to "WATSON"), AU2:AU1000) work?

Please help....

 

[rudevincy]

I have a sheet that has a list....

I am trying to count the number of 1 in range AU2:AU1000 but only if the value in range AC2:AC1000 is equal to "WATSON"

would COUNTIFS((AU2:AU1000=1, AC2:AC1000 = "WATSON"), AU2:AU1000) work?

Please help....

 

[steve the fish]

=COUNTIFS(AU2:AU1000,1,AC2:AC1000,"WATSON")

is what you are after

 

[rudevincy]

Thank you very much that worked