View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Neil Neil is offline
external usenet poster
 
Posts: 173
Default 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