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)