Vlookup help with a specific goal

[MaureiraMat]

Hello,

I have a question about vlookup.

I have a work book open with over 10000 lines. In (A) have a resource name like "Final", "3-Axis"

In column (O) I have number of "days late", In column (P) I have number of "days aged".

If i wanted to find out how many jobs I have under each "resource" name that has "days aged" grater then 3 days what would my forumal be ?

Is it a v look up formula?

The work book is being updated every day and lines are being removed and added.

Thank you for help in advance!!

Mat

 

[123rickfear]

=countifs(A:A,"Final",P:P,">"&3)

obviously you can change "Final" to a cell reference and the 3 to a cell reference.

If you don't have a list of all resource names, I can help you with a formula for that too.

Rick