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
.
|