Home |
Search |
Today's Posts |
#1
|
|||
|
|||
formula Problem
{=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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 wrote in message ... {=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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with formula in Excel | Excel Worksheet Functions | |||
Formula problem on network | Excel Discussion (Misc queries) | |||
problem with Array Formula | Excel Worksheet Functions | |||
Problem with formula | Excel Discussion (Misc queries) | |||
Need a formula for this problem | Excel Worksheet Functions |