It works with the brackets but doesnt without them?



"Bob Phillips" wrote:

No you don't. If you have a problem it is not that.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Hamish" wrote in message
...


"Hamish" wrote:

I thought i would add, what i am using atm is

=SUMPRODUCT(--(ColorIndex(E10:E172)=52); --(B12:B172="R"))

But that does not work it just comes up with #value

I have also tried to use a , to separate instead of ; but it gave errors

Ok I think i might have got it. it should look like

=SUMPRODUCT(--(ColorIndex(E10:E172)=52);--((B10:B172)="R"))

need the extra set of brackets