Countif only takes one criterium. To use several criteria, you can use the
sumproduct( ) function.
= sumproduct( ($A$2:$A$100=1) * ($B$1:$B$B10030) * 1)
-- sums 1 for all cells of A1:A100 equals to 1 AND (*) all matching cells
of B1:B100 greater than 30.
You can add as many criteria as you want.
--
Regards,
Sébastien


"Visual" wrote:

I have a spreadsheet of workorders showing various fields.
In the report i can count the amount of jobs overdue by 30 days. I can do a
count of how many jobs are priority 1. However i don't know how to right a
formula that is going tell me how many priority one jobs are overdue by 30
days. It seems easy but I don't know.

For eg. Priority ......... Age
1 23
1 35
I have attempted a few formula such as
=sumif(sheet!$:$,1,sheet!$:$)-countif(sheet!$:$,"30") something like that.