Hi

=SUM(IF(Mackay!E2:E5000=1,IF(Mackay!L2:L500030,1, 0),0)) I entered this
formula and it didn't work it returns a value of 0. I checked and yes its
not meant to be zero.

"Mangus Pyke" wrote:

On Sun, 17 Jul 2005 23:29:02 -0700, 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.

Use an array formula.

(Assuming that your priorities are in A1:A3 and your ages are in
B1:B3)

Enter: =SUM(IF(A1:A3=1,IF(B1:B329,1,0),0))

And confirm by pressing Ctrl+Shift+Enter
--
"Learning is a behavior that results from consequences."
B.F. Skinner