I have 12 different worksheets created, each of them labelled as Jan, Feb, Mar... Dec
There is another worksheet called Summary, which is sum of corresponding cells in those 12 worksheets.
However, some cells may be "N/A", so the sum may return "N/A" in Summary sheet.
How can I avoid this situation i.e. I only want to sum cells without "N/A"?
Thank you
There is another worksheet called Summary, which is sum of corresponding cells in those 12 worksheets.
However, some cells may be "N/A", so the sum may return "N/A" in Summary sheet.
How can I avoid this situation i.e. I only want to sum cells without "N/A"?
Thank you