What functions should I use?...please assist.

E

edk256

I have a problem with Excel. I have a worksheet with two columns. In
one column is a date when an event was due, and in the other, when it
was completed. What I want to do is to easily figure out how many
items were completed after they were due.

What I would like to do is have Excel recognize that one date (the
completed date) is after the due date, and if that were true, to
generate the number 1 in a third column, in the same row for that
event. After this I would simply sum the 1s in this third column to
get the result.

What would the function or series of functions be to recognize that if
one value in one column is larger the other value in the other column,
to insert a value (1) into a third column?

I would want to apply this to several hundred rows, and hence, events.

Thank you in advance.
 
M

Mr. Smith

edk256
Given that your due date is in columm A and the complete date in column B
this forumla will return 1 if complet date is "bigger" than due date.
=IF(B3>A3;1;"")
The formula will leave the cell blank if due date is "bigger" or the same as
complete date.

Mr. Smith
 
A

Ardus Petus

You could simply enter following formula that will calculate the total
number of rows where completed > due:

=SUMPRODUCT(--(A1:A100>B1:B100))

If you DO want to apply your method, enter:
=--(A1>B1)
and drag down

HTH
 
Top