Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formulla
=SUM(IF(NOT(ISBLANK('Open actions from LL'!$F$4:$F$987)),IF
('Open actions from LL'!$C$4:$C$987=$H5,IF('Open actions from LL'!$F$4:$F$987<$B$2+14,1,0),0),0)) Hi, I need to put a curley bracket {} at the begining (brfore =SUM) and end of the formula. I know I need to use ctl and shift butotn but can't figure out how to add it. Please help!!!! TIA, Hoque |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formulla
Hi Hoque
just enter the formula and then instead of hitting ENTER alone hit CTRL+SHIFT+ENTER together a sidenote: I would change your formula to something like: =SUMPRODUCT(('Open actions from LL'!$C$4:$C$987=$H5)*('Open actions from LL'!$F$4:$F$987<$B$2+14)) should return the same as has not to be entered as array formula (will get a count of all entries with the value of H5 in column C AND the value of B2+14 in column F) HTH Frank Hoque wrote: =SUM(IF(NOT(ISBLANK('Open actions from LL'!$F$4:$F$987)),IF ('Open actions from LL'!$C$4:$C$987=$H5,IF('Open actions from LL'!$F$4:$F$987<$B$2+14,1,0),0),0)) Hi, I need to put a curley bracket {} at the begining (brfore =SUM) and end of the formula. I know I need to use ctl and shift butotn but can't figure out how to add it. Please help!!!! TIA, Hoque |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formulla
Thnak you Frank.
Appreciated -----Original Message----- Hi Hoque just enter the formula and then instead of hitting ENTER alone hit CTRL+SHIFT+ENTER together a sidenote: I would change your formula to something like: =SUMPRODUCT(('Open actions from LL'!$C$4:$C$987=$H5)* ('Open actions from LL'!$F$4:$F$987<$B$2+14)) should return the same as has not to be entered as array formula (will get a count of all entries with the value of H5 in column C AND the value of B2+14 in column F) HTH Frank Hoque wrote: =SUM(IF(NOT(ISBLANK('Open actions from LL'! $F$4:$F$987)),IF ('Open actions from LL'!$C$4:$C$987=$H5,IF('Open actions from LL'!$F$4:$F$987<$B$2+14,1,0),0),0)) Hi, I need to put a curley bracket {} at the begining (brfore =SUM) and end of the formula. I know I need to use ctl and shift butotn but can't figure out how to add it. Please help!!!! TIA, Hoque . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formulla for Figur convert to Words | Excel Discussion (Misc queries) | |||
Place Stored Path Into Formulla | Excel Discussion (Misc queries) |