Can someone help me make sense of the following....
=1-(SUMIF('Project Resource Plan'!$A$3:$A$124,$B27,'Project Resource Plan'!AW$3:AW$124)+SUMIF(Completed!$A$2:$A$373,$B27,Completed!AW$2:AW$373))
I assume the "=1" means if the code is correct then fill "1" in the cell?
what is the dash (-) after the 1 ?
'Project Resource Plan' and 'completed' are other sheets in the workbook.
What does the $ mean?
what is the semicolon represent.?
There are 2 "IFs" do both have to be completed for a "1" to be inserted into the cell?
any advice appreciated.!
Thanks
Chris
=1-(SUMIF('Project Resource Plan'!$A$3:$A$124,$B27,'Project Resource Plan'!AW$3:AW$124)+SUMIF(Completed!$A$2:$A$373,$B27,Completed!AW$2:AW$373))
I assume the "=1" means if the code is correct then fill "1" in the cell?
what is the dash (-) after the 1 ?
'Project Resource Plan' and 'completed' are other sheets in the workbook.
What does the $ mean?
what is the semicolon represent.?
There are 2 "IFs" do both have to be completed for a "1" to be inserted into the cell?
any advice appreciated.!
Thanks
Chris