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

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

However, I don't know if it was a typo or not, I see in your formula that you
have written ($L$4:$M$3000=1) and the M should be an L (or the M should be
an L - either way, both sides of the : need to refer to the same column).
You might try changing that before using what I suggested. Don't forget
after editing to use the 3-key entry to commit it.
If that doesn't fix it, let us know. I think what you want to be done could
also be done with SUMPRODUCT().



"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

Thanks Guys

That has worked perfectly! And in the process made my day a lot easier!
Yes it was a typo thanks for pointing it out.

"JLatham" wrote:

However, I don't know if it was a typo or not, I see in your formula that you
have written ($L$4:$M$3000=1) and the M should be an L (or the M should be
an L - either way, both sides of the : need to refer to the same column).
You might try changing that before using what I suggested. Don't forget
after editing to use the 3-key entry to commit it.
If that doesn't fix it, let us know. I think what you want to be done could
also be done with SUMPRODUCT().



"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