YTLE#102: Count Dates given 2 Criteria - Excel

Hi Folks,

basically, I think I'm 'nearly' there with this one - at present I have the following formula:

{=COUNT(IF(Cum!$G$3:$G$2000<"10/5/2010",Cum!$R$3:$S$2000,"BT Delivery"))}

and it is returning a value of 3537 but it should only return the value of 15.

Column G is a date column & Column R/S is a merged column containing 7 different criteria, one of which is BT Delivery .

What I am trying to do is count the number of times that a cell with the value "BT Delivery" occurs within Column R/S before 10 May 2010 (where the dates, on separate rows, are in Column G)

Any assistance you can provide would be very gratefully received.

Many thanks

John

Want to count the number of days between days and given other criteria.

See example Below -

Date Name
5 Dec 2007 Toney
2 Jan 2008 Dan
3 Jan 2008 Toney
10 Jan 2008 Dan
3 Feb 2008 Toney
12 Feb 2008 Toney

If I want to querry how many days Toney has come between 1st of Jan and 10 Of february what would the formula be? (the answer should be 2 as Toney has only come twice during the spcified period)

please note that Date column is in Date format.

thanks. appriciate your effort.

Date Received Concur/Ref Instrument 17/07/2009 Frog 21/07/2009 Koala 02/10/2009 Koala Koala between 01/07/2009 - 30/06/2010 3 23/11/2009 Koala Frog between 01/07/2009 - 30/06/2010 3 09/07/2010 Koala 17/05/2010 Frog 17/05/2010 Frog 26/07/2010 Koala 26/08/2010 Koala 13/10/2010 Koala

Hi there - hoping someone can give me a bit of help please.

I have a huge spreadsheet that I need to calculate how many times something occurs between two dates.

For example above I need to know how many times Koala appears between 01/07/2009 and 30/06/2010. Is this possible?

I have tried the following with no luck

=SUMPRODUCT((B1:B11="Koala")*(A1:A11>"01/07/2009")*(A1:A11

Hi, I'm trying to set up a formula to count the number of entries between two dates in one column if they match a criteria in another.

i.e. if my data is as follows:
A_____:B
Blue___:1/01/2010
Green__:3/03/2010
Blue___:2/01/2010
Blue___:31/09/2010

I want to count Blue entries between 01/01/2010 and 30/01/2010.

So in this example the result I want is 2.

What formula can I use to do this, I've a feeling SUMPRODUCT is involved but I've had no success getting it to work... Any help would be much appreciated.

Dear Sir

I have a table with 2 Date Columns for Incoming Emails and Outgoing Emails. In the 3rd Column I calculate the difference in hours between these 2 Dates.

I am unable to figure out a formula which can give me the count of emails answered or sent (outgoing email) within 24 hours.

Could anyone help me out please...many thanks for your efforts !!

******** ******************** ************************************************************************> Microsoft Excel - Book1 ___Running: xl2000 : OS = Windows Windows 2000 (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout E4 E5 E6 E7 E8 =
B C D E F 2 * * * * * 3 * EMail*Received*Date Email*Sent*Date Difference*in*Hrs * 4 * 5/29/07*4:00*AM 5/30/07*6:00*AM 26:00:00 * 5 * 5/29/07*4:00*AM 5/29/07*6:00*AM 2:00:00 * 6 * 5/29/07*4:00*AM 6/1/07*6:00*AM 74:00:00 * 7 * 5/31/07*9:00*AM 6/1/07*6:00*AM 21:00:00 * 8 * 6/22/07*3:00*AM 6/22/07*9:00*AM 6:00:00 * 9 * * * * * Dates *
[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

I am trying to count the days between 2 dates. Start date 01/01/01 and End
date 01/05/01 should return 5. However the Datediff function will return 4
because it doesn't count the start date. Adding "+1" to the Datediff function
does not work for me because when the cells with the start and end date are
empty the cell with the Datediff function must be empty.

HI,
Any help!! I am trying to insert a furmula in Excel that will count the number of entries in a column that have a past due date from today (today being variable to the day that I open my worksheet).

So I am working on a weighting system based on the length of a person's term, and am weighting it by the number of months. How can Excel do this. For example, if the two dates are Jan 1st to Apr 5th, the count should be 3 months. I know Excel can count the days, and I know it is able to find the month number using =MONTH([date]), but this would not be helpful for people who have been on the term for multiple years. Thanks for any help.

I need help with writing this formula

In sheet 2 i have col headings for each month, under each month I want a formaula to cacl:

If col a on sheet 1 = the word Open, then count col b on sheet 1 only if it = the word JAN

Basically what I am trying to do get the count of "open" in the month of "Jan". I can then copy the formula to each month column on my totals sheets

Thanks

Hello
Hopefully some kind person can assist with this.
I have a worksheet with n number of rows (can vary from 30 to 3000) and
columns from a to m (13). I need to count the number of times that column L
value exceeds 120 when column E = a pre defined value. This pre defined value
can equal 320, 744, 743, 73H and many more.
I have a table set up that has these required "pre defined values". Keep in
mind that this table is dynamic, values can be added or deleted. The
reference for this table is on another worksheet "table" A1..A15. I don't
mind where this table is located, it just happens to be in this seperate
worksheet.
I can sort or filter however I was wondering if there was a better way to
count the occurrences.
Many thanks
Regards
Allan