formula help

		Microsoft Office Forums > Microsoft Excel > Excel
formula help

FAQ

Thread Tools

Display Modes

03-25-2012, 08:49 AM

excelledsoftware excelledsoftware is offline

Windows 7 64bit formula help

Office 2003

IT Specialist

Join Date: Jan 2012

Location: Utah

Posts: 455

excelledsoftware will become famous soon enough

Quote:

Originally Posted by Pecoflyer

Did you use large ranges hat time ? Like A1:A65535 ? That would slow thing down
If necessary Dynamic ranges are best

You know I think I did. It was shortly after I discovered the sum if formula which was much more effective for the application I was doing. But it is evident now that the sumproduct formula is exactly what I needed. Thanks again I will mark as solved.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula Help - Look and if and that	Corca	Excel	2	02-05-2012 09:18 AM
help with a look up or if formula	beb1227	Excel	3	12-31-2011 01:08 PM
help with formula?	doczilla	Excel	2	09-25-2011 04:14 PM
Help with formula please.	AndrewSE	Excel	3	04-05-2011 08:50 PM
Help with Formula	Corca	Excel	6	02-22-2010 09:40 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:42 AM.