formula help

		Microsoft Office Forums > Microsoft Excel > Excel
formula help

03-24-2012, 03:03 PM

excelledsoftware excelledsoftware is offline

Windows 7 64bit formula help

Office 2003

IT Specialist

Join Date: Jan 2012

Location: Utah

Posts: 455

Quote:

Originally Posted by Pecoflyer

Perhaps

Code:

=SUMPRODUCT(($A$2:$A$6=G2)*($B$2:$B$6<=E2))

Last time I used this technique it slowed the spreadsheet way down. I just entered them all and it seems to be working fine with it. Thanks so much

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 08:32 AM.