Using Conditions - cell colour and cell containign text
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
|