Thread: Formulla
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Hoque Hoque is offline
external usenet poster
 
Posts: 1
Default 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