Use lowercase w

To an XL formula W and w are equal. ="W"="w" returns TRUE

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Gary''s Student" wrote in message
...
Use lowercase w
--
Gary''s Student - gsnu200765


"Byron720" wrote:

I have the following data:

w 1
w 1
w 2
w 1
w 1
c 3
w 2
c 1
c 1
w 3
c 1

I need a formula that calculates how many of the w's have numbers greater
than 1. I was trying this formula:
sumproduct(--(C2:C12="W"),--(D2:D121))
but it doesn't work.