Calculating a formula that exceeds 1,000 characters

Posted to microsoft.public.excel.worksheet.functions

w1nter11

Posts: n/a

Calculating a formula that exceeds 1,000 characters

I have a formula that needs to sum the following cell ranges formula ex.
=(C5*$C$3) all the way to (CZ5*$CZ$3). I am assuming it stops because a
formula can only have 1024 characters. Any suggestions????

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
Formula Problem - interrupted by #VALUE! in other cells!?	Ted	Excel Worksheet Functions	17	November 25th 05 05:18 PM
Formula checking multiple worksheets	sonic-the-mouse	Excel Worksheet Functions	2	June 5th 05 03:28 AM
Remove characters from a text string using a formula	duncrbrt	Excel Discussion (Misc queries)	1	June 4th 05 02:19 AM
if cell starts with characters formula	Norman Kong via OfficeKB.com	Excel Discussion (Misc queries)	3	March 24th 05 10:18 AM
Problem with VBA returning the contents of a long formula.	[email protected]	Excel Discussion (Misc queries)	2	February 23rd 05 12:14 AM

All times are GMT +1. The time now is 11:25 PM.

Menu

About Us