Multiple criteria lookup counting

[Boxxel]

Hey guys,

I am not very good with the formula side of excel, but I am trying to learn. I have been using the countif formula for a lot of my data counting which has worked so far. Here is my question. I am trying to count by quarters for the year. We have a field that we use that has the date and then we add another number, for example, 08131402 would mean we are on the second order for the day. I have another 5 columns on the same sheet that we use that has a letter and a number, for example T54. I would like it to count lets say the first quarter which is Jan through March how many times T54. Both fields are text field and when I tried dcounta I was getting an error message, and when I tried countifs I was getting an error. How would I go about doing this. If you need more explanation, please ask.

Thanks in advance.

Joe

[judgeh59]

can you upload a small data set after removing any company confidential data?...It would make it easier to help....thanks

[Boxxel]

I uploaded a file.

[judgeh59]

I'm Sorry....I didn't scroll down and see that....OOPS!!....yes, I'm getting old

[Boxxel]

I want to clarify also, that I was able to get it to work if I select the exact range. I want it to be ongoing. I tried choosing for the date 01* and it will pick up the first month for example. This way I will have all the way till the end of the year without having to wait until the end of the year to get my data.