Hello.

I'd like to ask for some ideas on how to do the following.

I'm trying to build a report that will match multiple projects and required
"workload days needed" against multiple "workload available" resources.

A simple layout of the Excel would be in 2 blocks of data.

1st is:
Project, Project Ranking (what should be done first), resource assigned,
project days needed and Can it be done? determination.

Project Ranking Resource Project Days Needed Can Be Done?
A 1 Manuel 10 Yes
B 2 Cindi 10 Yes
C 3 Cindi 10 Yes
D 4 Cindi 10 Yes
E 5 Cindi 10 Yes
F 6 Maynard 10 Yes
G 7 Maynard 10 Yes
H 8 Maynard 10 No
I 9 Cindi 10 No

The second table matches Project Days needed against available resources.

Resource Project Days Available Project Days Needed Delta
Manuel 20 10 10
Cindi 40 50 -10
Maynard 20 30 -10

I can get the days needed from the sumif function.

My questions:
1) What would be the formula to write for the "Can Be Done?" column in the
first block of data? I have a concept of tracking the cumulative days needed
by person to compare against days available... but I'm stuck on the formula.

2) Would the resulting formula recommended be robust enough if I had to
resort the rankings?

3) Can this be done in a pivot table?

Thanks to this great community for all its help!
--
Thanks,

Morocco Mole