I am trying to use the following formula but getting an error:
Can someone please tell me what is wrong with this formula and how this can be rectified? Thanks.SUMIF('Data Input Sheet'!$B$12:$B$20,"Detailed",SUMIF('Project Summary'!$M$5:$M$13,"SubContractManual",'Data Input Sheet'!$E$43:$E$51))
Bookmarks