Formula for if name begins with and date is less than or equal to.

Posted to microsoft.public.excel.worksheet.functions

Senor Martinez[_2_] Senor Martinez[_2_] is offline

external usenet poster

Posts: 7

Formula for if name begins with and date is less than or equal to.

Im trying to create a formula that gives me a total count for cells that are
less than 02/05/10 and the name begins with FHLM, on previous post teethless
mama helped me w this, but im still getting a value of 0. Someone please
help!!

=SUMPRODUCT(--(E1:E100<=DATE(2010,2,5)),--(LEFT(U1:U100,4)="FHLM"))

Thanks in advance.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
conditional formatting for cell date to equal today's date	Sistereinstein	Excel Worksheet Functions	2	September 10th 12 07:53 PM
Formaula for less than date and name begins with...!!! HELP!!!	Senor Martinez	Excel Worksheet Functions	4	February 5th 10 09:04 PM
sumif date is greater than or equal chosen date	Gary	Excel Discussion (Misc queries)	2	September 19th 08 09:51 AM
VLookup If Date is equal to the Day	dandiehl	Excel Discussion (Misc queries)	7	April 9th 08 11:59 PM
Date Validation - Must equal Sundays date	jeridbohmann	Excel Discussion (Misc queries)	14	November 30th 05 08:40 PM

All times are GMT +1. The time now is 11:23 AM.

Menu

About Us