I have a workbook that will have total 13 sheets; 12 for each month Jan to Dec and 13th is the summary. I will call the data from each of the 12 sheets into the 13th sheet. A new sheet for each month would be created at the beginning of each month. Meanwhile I set up formula in the the summary sheet to call data for all the months whenever the file is opened. Right now I have only January sheet created in the workbook. I dont have any other month sheet in the workbook. At this point for February to December when I call the data, it gives me #value! error and what i understand is that it is because the refered sheets donot exist. Can I get a blank cell instead of this error? I use the following formula in the summary sheet:
=SUMIF(February!$L$3:$L$13,"=???5*",February!$M$3:$M$8)
The above code works fine when used to get January data in summary sheet.
any help appreciated.
=SUMIF(February!$L$3:$L$13,"=???5*",February!$M$3:$M$8)
The above code works fine when used to get January data in summary sheet.
any help appreciated.