Sorry just another quick one.

=SUMPRODUCT((Mackay!$E$1:$E$5000=1)*(Mackay!$L$1:$ L$500030)*(Macakay!$L$1:$L$5000<60)) how would I make this one work. Jobs between 30 and 60 days

Thanks.

"Visual" wrote:

It worked. What is it with the row selection. Why cant u have A:A u need
A1:A1000. Interesting

"KL" wrote:

sorry, I meant =SUMRPODUCT((A1:A10=1)*(B1:B1029))

KL

"KL" wrote in message
...
Hi,

Try this:

=SUMRPODUCT((A1:A10=1)*(B1:B1030))

Regards,
KL


"Visual" wrote in message
...
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.