Shouldn't be difficult

=IF(C5="Yes",SUMPRODUCT(--($A$1:$A5=A5),--($B$1:$B5=B5),--($C$1:$C5="Yes")),
IF(C5="No",SUMPRODUCT(--($A$1:$A5=A5),--($B$1:$B5=B5),--($C$1:$C5="No")),"")
)


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Neil" wrote in message
...
That is perfect Bob thank you, is it possible to adapt it to count
different
text in the C column such as "no" as well as the "yes" but in a seperate
count?

Thanks again it was a big big help

"Bob Phillips" wrote:

Neil,

This may not be exactly what you want, post back if not, but try


=IF(C1="Yes",SUMPRODUCT(--($A$1:$A1=A1),--($B$1:$B1=B1),--($C$1:$C1=C1)),"")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Neil" wrote in message
...
Yes sorry Bob i can see i am writing in a language only i seem to
know!!
The
code almost works it does what i need it to except that the count also
apears
in column D when column C is empty ie no "yes" in it.
It doesn't include it in the count just displays what the current
count is
it would be usefull for me if it only appeared when the yes is in
column
C.
But otherwise it is great

Thank you very much for the help

"Bob Phillips" wrote:

Neil,

You have a knack of stringing together words that I understand into
sentences that I don't <G

Here is a shot at what I think you mean though. Put this in D1 and
copy
down

=SUMPRODUCT(--($A$1:$A1=A1),--($B$1:$B1=B1),--($C$1:$C1="Yes"))


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)