Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
custom format or conditional format? | Excel Discussion (Misc queries) | |||
How to create a conditional format that changes the number format | Excel Discussion (Misc queries) | |||
Conditional Format - Format Transfer To Chart | Excel Discussion (Misc queries) | |||
copy conditional format to regular format | Setting up and Configuration of Excel | |||
copy conditional format as ACTUAL format | Excel Discussion (Misc queries) |