Using COUNTIF to calculate number of negative or positive results

Hi, I have a spreadsheet full of information pertaining to orders. In one column I have the expected delivery date, in another I have the actual despatch date. In another column I have a calculation that works out the number of days from one to the other. This column may show results as 0 - where the order was despatched the day it was ordered, a "-number" where it was so many days earlier than anticipated, and a "number" where it was so many days late.

I want to analyse this data to show how many orders were on time or early (e.g. 0 or "-number") and how many are late.

How do I use COUNTIF to count the "-numbers" or "numbers"? Counting the number of "0" was easy enough.

Or can anyone advise how better I can show this data?

Thanks!

Another thought - I guess what I'd like to do is show the percentage of total orders which were on time or early, and the percentage that were late.

Hi -

Assuming your data is in column A, you could use somthing like:

=COUNTIF(A:A,"<0")/COUNT(A:A)

That would give you the decimal of the negative numbers relative to all the numbers. Just change the criteria for positive numbers ">0". Format the cell as %.

Hope this helps.