countif multiple criteria

Hi All, I am trying to count a column in excel, range of A2:A200 and need to count the number of cells that contain dates and not free text. Can only think of COUNTIF, but having major problems with this. Any help would be great. Lyle

I'm trying to count non blanks in JCN and if Unit is UN10. I have about a 2500 line item data base that I want to automate a report out of. I did a countifs in 2007 but can't figure it out in 2003. Any help would be greatly appreciated. <TABLE style="WIDTH: 165pt; BORDER-COLLAPSE: collapse"...

Need a bit of help with this. Doing a project for a made up hotel, in essence I have 3 columns, Arrival date, leave date, and rate. Arrival date and leave date are self explanatory. The rate is either: "EB", "NP" or "WI", and the rate is decided based on when the room was booked, but is not...

I'm trying to figure out how to find out how to make the countif and sum if functions work for a table that uses cash values. I want excel to count records in a column that are greater then X but less then Y. I have used the help function and it says to use this: =countif(E:E,">5"&"<=10") When I...

Need help on how to make a CountIFS count if it meets one of my criterias OR another intead of AND another. The data is words not numbers. Thanks for any help!

I have a ss of days, with hours worked. I wish to count the completed rows for normal working days in the month. Col B contains the day of the week ("Mon","Tue","Sat" etc) or "STAT" Col G contains the number of hours worked (a formula that shows "" if blank) I wish to count the rows where...