Hi All

I have a question relating to the CountIF function. I have a need for a
function which uses countIF but the value meets a criteria from 2 columns (or
alternatively has two sets of criteria)

I can get it to work for one column but not two
=COUNTIF('column if data '!D2:D463,"=Yes")

I have tried to add (and 'column of data2 '!E2:E462," =No") and various
variations of the above but no joy

Do you have any suggestions (maybe a countIF is not the way to go)

Any help greatly appreciated

Cheers Rexmann