Microsoft Office Forums - View Single Post - [Solved] formula help

Thread: [Solved] formula help

View Single Post

Old

03-24-2012, 03:03 PM

excelledsoftware excelledsoftware is offline

excelledsoftware is offline

excelledsoftware uses Windows 7 64bit

Windows 7 64bit excelledsoftware uses Office 2003

excelledsoftware uses Office 2003

Office 2003

IT Specialist

The original poster

Join Date: Jan 2012

Location: Utah

Posts: 455

excelledsoftware will become famous soon enough

Default

Quote:

Originally Posted by Pecoflyer

View Post

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

Reply With Quote