formula for multiple criteria

[phoenixphi]

I have gone through the treads and can not seem to find a solution to my problem - apologise if it has been answered and i have missed it.

Basically, what i am trying to do is have a formula which will return the number of occurrences when certain criteria are met. I have column A that shows whether the item is overdue or not by showing the word overdue. in column C i have the name of the person responsible and in column D i have the date when completed (which removes the overdue from column A).

Col A Col C Col D
Overdue A N Other "blank"
"Blank" A N Other 01/01/01

Total = 1

Is there a formula that will return the value 1 without having to manually count? i have over 1000 lines to check.

Many thanks in advance for your help!

[npamcpp]

To count overdue items

=countif(A:A,"overdue")

to count all other items

=countif(D:D,">0")

[phoenixphi]

i solved this with the following;

=SUM(A2:O50=Q120)*(Q2:Q50=O120)*(R2:R50=0))
then CTR+SHIFT+RETURN to confirm

it worked a treat!

[Palmetto]

You mention having multiple criteria, but don't clearly define them beyond "overdue"
Are you wanting to count overdue items relative to a name?

If so, then try using a SUMPRODUCT formula

=SUMPRODUCT(--($A$1:$A$1000="overdue")*($C$1:$C$1000="Name"))

Where "Name" is the actual name of the person

Also, consider using a Pivot Table - it provide the best flexibility.