=COUNT issues

[Traun2445]

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

 

[pjmorris]

Traun,

Delighted to have helped. Google COUNTIF and you'll get lots of help.

Thanks for the feedback.

 

[pjmorris]

What is the answer of the question?

In #11 Traun stated:

I want to make sure I am clear and that the INC numbers will not include "INC" they will just be a number.

Which led me to think that since Dates are integers they are fundamentally the same as the incident numbers. My suggestion was to make sure that incident numbers are far in excess of any likely date hence countif(A8:A100, ">100000"). Not perfect, but appears to have been sufficient. I don't know of any other way to distinguish between an integer and a date?

Regards

 

[Traun2445]

Hello again,

It did do the trick! Works well now. Here is the next part of building that spreadsheet. I have all the functions working. However that is only for one day, and one incident:

7/19/2014

Total Emails:

Has to be entered manually

Standard INC's:

Pulls from "Type"

Urgent INC's:

Pulls from "Type"

Ticket Number

Type

Device Name

Email Alert Time

Date Device Restored

Time Device Restored

RFO

Drop down here with "Standard" and "Urgent"

<tbody>
</tbody>

1) I really want to be able to enter a new row once a new ticket number is entered, once A1 through A7 is done. Create a macro to create a new row B1 through B8, directly underneath it, with nothing filled in.

2) That means I need The "Standard INC" field - function is =COUNTIF(B8:B8,"Standard") and "Urgent INC" field - function is =COUNTIF(B8:B8,"Urgent") fields to be dynamic. I have no idea how to do that.

I would then Auto fill for each day of the month.

Any ideas on how to do this???

Thanks again for everyone's help!