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!
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!!!
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!
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!!!