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

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 05:11 AM.