I have been working on a goal tracking workbook that will track a variety of things. I've taken classes on Excel Years ago and have the basics down. However the more advanced formulas have escaped me.
I believe my method for tracking Sales increase will work However, it seems that the =Sum(A8:DB8) formula is having an issue. I think the issue is due to the cells that currently only have, a formula because those weeks have no data at this time.
I have attached the file in question and the issue I am having is on the STORE YEAR sheets. Cell B6 current Formula is =Count(C6:DB6) which produces a 400% with the data I have entered. I have also tried a simple =Sum(C6:DB6) but, it returned a #Div error.
Any information would be greatly appreciated,
Dhaark
Bookmarks