Little Willie

Posts: n/a

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Problem with formula in Excel	Bill R	Excel Worksheet Functions	3	August 15th 05 03:02 AM
Formula problem on network	Philip Reece-Heal	Excel Discussion (Misc queries)	2	July 1st 05 01:15 PM
problem with Array Formula	OrdOff	Excel Worksheet Functions	2	June 30th 05 04:57 PM
Problem with formula	Sundaram Iyer	Excel Discussion (Misc queries)	0	June 1st 05 12:49 AM
Need a formula for this problem	Trying to excel in life but need help	Excel Worksheet Functions	1	January 12th 05 11:05 AM

All times are GMT +1. The time now is 10:49 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us