I have a worksheet with the following structure:

Column A: Date (from 11/10/1996 - 31/12/2000)
Column B-Z: Data (Number)

In which some day's data are N/A.

I want to find out how many N/A records in each month, what am I supposed to do with VBA codes, thanks for all who offers me a suggestion.

Hi

Are the 'N/A' literal text or Error Codes

Cheers
Shasur

http://www.dotnetdud.blogspot.com

VBA Tips & Tricks (http://www.vbadud.blogspot.com)

The "N/A" records are entered as text by myself.

Thanks for your reply.

I am not sure if you have found a solution. I had trouble logging on to the forum for the past few days. Anyway, here are my notes:

I would add 2 columns. One to calculate the month number and the next using a COUNTIF formula to count the cells that contain "N/A" in each row.

At the bottom of your report I would add SUMIF formulas, one for each month, to count the totals by month from all rows.
e.g. in Cell AA1 add formula =MONTH(A1) & copy to all rows
e.g. in Cell AB1 add formula =COUNTIF(B1:Z1,"=N/A")
e.g. at the end of your data rows (this formula assumes 100 rows of data), add the SUMIF formulas for each month number =SUMIF(AA1:AA100,"=1",AB1:AB100), =SUMIF(AA1:AA100,"=2",AB1:AB100)

I hope I understood your problem.