formula Problem

[Little Willie]

{=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

[galimi]

Those squiqqly brackets ({}) are indicative of an array. You should be
pressing Ctrl-Shift Enter when finished with your edits, this is why your
formula adjustments are not working.
--
http://HelpExcel.com
1-888-INGENIO
1-888-464-3646
x0197758


"Little Willie" wrote:

> {=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

[Biff]

Hi!

Use this instead and you won't have to worry about those { } braces:

=SUMIF(Info!$J$13:$J$562,H53,Info!$T$13:$T$562)

Biff

"Little Willie" <Little Willie@discussions.microsoft.com> wrote in message
news:CD00DF2F-4086-42FC-A097-B32170F92EC0@microsoft.com...
> {=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