Excel: =COUNT issues

Hello! I am currently trying to add up how many incidents are created monthly. The incident is in column A. There are also dates in column A. I only want to add up how many incidents there were. I have tried many different ways and cannot get it to work!:confused: I thought I would be able to figure this out, but I have been defeated. I have tried stating if A8<>"", since that is the first cell that must contain an incident number. But that did not work, I tried COUNTIF, COUNTIFS, and still nothing. I tried figuring out to state if it is not a date, count it, but no luck with that either. Please help! THANKS!!!

This question generated 23 answers. To proceed to the answers, click here.

This thread is current as of July 20, 2014.

For more resources for Microsoft Excel