Hi,

I was wondering if someone could help me. I am trying to use the countif function to satisfy 2 conditions.

e.g. If criteria1 = "true" AND criteria2 = "true" then increment the count cell by 1.

At the moment it is adding up the value attained from criteria1 to the value attained from criteria 2.

Does anyone know how to do this?

Thanks

Rob