formula help

		Microsoft Office Forums > Microsoft Excel > Excel
formula help

FAQ

Thread Tools

Display Modes

03-24-2012, 01:00 PM

Pecoflyer

Windows 7 64bit formula help

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,915

Pecoflyer has a reputation beyond repute

Perhaps

Code:

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

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

« 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 02:08 PM.