Hi

You can use multiple Countif only in XL2007 with the COUNTIFS function.

Try
=SUMPRODUCT(('column if data '!D2:D463,"=Yes")*('column if data
'!E2:E463,"=No"))

Note the ranges have to be of equal length (perhaps you had a typo in your
posting)

--
Regards
Roger Govier

"rexmann" wrote in message
...
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