count data

Hi All - I'm wondering if there is some type of formula that will count the dates in a column and spit some numbers out. For instance, I have multiple dates in column A rows 1 - 100. I would like the total number of Oct dates in B1, Sept in B2 and the total number of Nov dates in B3. How can...

Dear Experts, Note: I'm using Excel 97. That's right. I have a huge set of data with a wide range of values. About 800 rows. One column. 0 1 24 56 75 2 8 45678 2 98 33356 32 etc. I'd like to make the table that you need to make the histogram. With counts in the appropriate cells...

I am counting 'no. of values' by using formula =COUNTIF(C59:C162,"?*")+COUNT(C59:C162). But it also counts 0 (zero). I want that it should not count 0s occurred in cells. How to accomplish?

A column W5:W9999 contains attendance from either of 0, 1, ........31 of employees. How to count no of employees meeting certain criteria like: Total no. of emp with values >0. Total no. of emp with values >0 but < 16.

I am a relative Excel novice, but have thoroughly explored MS Excel Help and other online help forums for an answer to my question, and at this point, I am wondering if what I want to do is even possible? Please help! I want the formula to return a single sum for multiple conditions (two, to be...

Hi, I want to match data from sheet1 with data in sheet2(Reporting matrix) using array formula in order to count the data. I used below macro that doesn't work. can any one help me to complet this. My thanks in advance! Sub Count() Dim Row As Integer, Col As Integer Dim x As Integer Dim y...