Reference sheet with a zero value issue

[wendell42]

I have a workbook that I use to track attendance for meetings, training's and a few specific duties. I have a worksheet for each individual I track where I put the totals each month. I have another sheet that references each individual sheet to give me a good overall view for all individuals.

The problem I am having is if someone attends Zero meetings for the month, the main sheet does not bring the zero value over. I am guessing this is BECAUSE it is a zero value. Is there any way to have the main sheet bring over the zero value?

Any assistance would be greatly appreciated.

Wayne

 

[BenGee]

When you say a zero value, is that literally what it says (number or word). Or, is it just a blank?

How is your overall sheet referencing to the other sheets?

 

[wendell42]

the value is the number zero (0)

I am just doing a simple reference from the individual sheets as follows =sheetname!cellnumber

It brings the numbers over fine, unless that number happens to be 0