Number of records depending on two conditions

[GrahamUK33]

I am looking for a formula that counts the amount of times ‘Temp’ appears in ‘2014’.

Column A column B
Temp 01/03/2014
Temp 01/04/2015
Temp 01/05/2014
Test 01/03/2014
Test 01/04/2015

Thanks very much in advance for your help.

[benishiryo]

hi there. try:
=COUNTIFS(A:A,"Temp",B:B," > =1jan2014",B:B," < 1jan2015")
remove the spaces i have in my formula. this website seems to have trouble with the larger and lesser than signs

do upload an excel sample so that we do not have to manually key in your data to do a testing.

input the desired results so that we don't have to second-guess if what we are doing is correct or not. you may look at my signature to upload an eg that is easier to understand.

the upload attachment must be done by going to Go Advanced. click on Manage Attachments. Choose file, upload and close the window.

if i really guessed it wrongly, please upload something according to my recommendations. try to use the solution i have given and we'll help to advise what went wrong.

[sandy666]

try:

Please Login or Register  to view this content.

[GrahamUK33]

try:

Please Login or Register  to view this content.

Thanks very much, this has solved the issue.

[JohnTopley]

IIf that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[sandy666]

Thanks very much, this has solved the issue.

You are welcome and thanks

Have a nice day