{=SUM(IF(Info!$J$13:$J$562=H53,Info!$T$13:$T$562,0 ))} This is what I see in
the formula box. When I change the range to make the cell range longer ....
(change cell 562 to 1000) the formula either zeros out on me. Acctually, it
zeros out on me if I change the cell range at all. Not sure what is wrong??

Also, why is excel putting "{}" those symbols around my formula.

Thanks,
TS