Countif

Hi wondered if anyone could advise what would be the best formula to use. I've been trying countif with no success.

I have a spreadsheet with a number of different columns
KILL DATE TIME LEFT TIME ARRIVED PH Overnight (Yes/No)
30/08/2013 15:30 17:00 5.48 No
30/08/2013 NR NR 5.41 Yes
30/08/2013 06:30 11:40 5.47 No
04/09/2013 05:35 07:20 5.29 Yes
05/09/2013 10.05 14:40 5.71 No

What I would really like is to be able to Count how many times a pH is less than 5.30 in August; pH is between 5.30 and 5.69 in August; pH is over 5.7 in August, same for September etc.

I have used the following for a simpler query:
=COUNTIFS('2013'!$a$1:$a$5,">=01/08/2013",'2013'!$a$1:$a$5,"<=31/08/2013",'2013'!$e$1:$e$5,"Yes"), which works fine but if i try
=COUNTIFS('2013'!$a$1:$a$5,">=01/08/2013",'2013'!$a$1:$a$5,"<=31/08/2013",'2013'!$d$1:$d$5,">=5.30",'2013'!$d$1:$d$5,"<=5.70") I have no joy.

i should mention that the '2013' referred to is the workbook that contains the data (trying to do the queries on a Stats workbook).

Anyone any ideas?

Many thanks

Chris

Use

=COUNTIFS('2013'!$a$1:$a$5,">=01/08/2013",'2013'!$a$1:$a$5,"<=31/08/2013",'2013'!$d$1:$d$5,">="&5.30,'2013'!$d$1:$d$5,"<="&5.70)

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

Better to use cells to hold the criteria:

A2 = 1/8/2013
B2 = 31/8/2013
C2 = 5.3
D2 = 5.7

=COUNTIFS('2013'!$A$1:$A$5,">="&A2,'2013'!$A$1:$A$5,"<="&B2,'2013'!$D$1:$D$5,">="&C2,'2013'!$D$1:$D$5,"<="&D2)

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.