Hi all
Can you please help me to break this down:
=1-(SUMIF('Project Resource Plan'!$A$3:$A$119,$B10,'Project Resource Plan'!G$3:G$223)+SUMIF(Completed!$A$2:$A$373,$B10,Completed!BA$2:BA$373))
I assume it is saying "put a 1 here" if....... certain criteria from the 2 sheets is met?
Why are both sheets mentioned twice ?
What IS the criteria!?!
Thanks
Can you please help me to break this down:
=1-(SUMIF('Project Resource Plan'!$A$3:$A$119,$B10,'Project Resource Plan'!G$3:G$223)+SUMIF(Completed!$A$2:$A$373,$B10,Completed!BA$2:BA$373))
I assume it is saying "put a 1 here" if....... certain criteria from the 2 sheets is met?
Why are both sheets mentioned twice ?
What IS the criteria!?!
Thanks