Formaula for less than date and name begins with...!!! HELP!!!

S

Senor Martinez

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, heres what i came up
with...

=COUNTIF(E:E,">="&DATE(1900,1,1))-COUNTIF(E:E,">="&DATE(2010,2,5))+COUNTIF(E:E,DATE(2010,2,5))-COUNTIF(U:U,"FHLM*")

I keep gettin a bunch of ###### or 0, depending on how I move the data
around..

Any ideas????
 
S

Senor Martinez

Thanks mama, but now im getting a value of 0??!!

any other ideas? this is how i typed it
=SUMPRODUCT(--(E1:E89000<DATE(2010,2,5)),--(LEFT(U1:U89000)="FHLM*"))
 
D

David Biddulph

Yes, zero is the answer which your formula is certain to return.

Why did you change --(LEFT(U1:U100,4)="FHLM"))
to --(LEFT(U1:U89000)="FHLM*")) ?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula for if name begins with and date is less than or equal to. 5
Count within a date range 3
Can I use COUNTIF for 2 separate IF queries? 5
Monthly job timings analysis - automation options? 2
Sum Where Date is less than certain date 5
Help with conditional formula for greater/less than 3
Formula calculating slack time greater than or less than a number 3
Sumif....date in table is greater than compared to date 1

Top