Formulla

H

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
 
F

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
 
G

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



.
Click to expand...
 
Top