Thread: Sum if function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kishor Bhalerao[_2_] Kishor Bhalerao[_2_] is offline
external usenet poster
 
Posts: 4
Default Sum if function

Hi,

I am working on a report in which i have gone through the forumla
{=SUM(IF((('Open Detail'!$B$2:$B$5210="FMS")*(('Open
Detail'!$F$2:$F$5210="IR")+('Open Detail'!$F$2:$F$5210="PR"))*(('Open
Detail'!$O$2:$O$5210<2))),1,0),C13,D13,E13,G13)}. I am not able to understand
what is '{' before the formula gets started. When i click on the formula the
'{' signs does not display. Pls suggest..