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

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

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


.