Conditional format?
Hi
I wonder if any one can help me please.
I have been given a formula that i have seen work in another sheet but i
can't seem to get it to work for me. I was told to puch control+shift+enter
to get it to work. but i have tried this but it doen't.
The formula is
{=SUM(IF(($J$4:$J$3000="RW1")*($K$4:$K$3000="FRIDA Y")*($L$4:$M$3000=1),$G$4:$G$3000))}
It is the { } that seem to make it not work
Many thanks
|