Formulla

[Hoque]

=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

 

[Frank Kabel]

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

 

[Guest]

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



.