Neil,

You use ctrl+shift+enter to specify array formulas. You can spot array
formulas by looking at them because they will be enclosed in curly braces.
However, you are not supposed to type in the curly braces. Excel puts them
automatically. So, what you need to do is enter the formula without the
curly braces, then ctrl+shift+enter.

=SUM(IF(($J$4:$J$3000="RW1")*($K$4:$K$3000="FRIDAY ")*($L$4:$M$3000=1),$G$4:$G$3000))


"Neil" wrote:

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