Okay, I am trying to write a formula using Excel 2003 that will give me a count of the items listed in another tab. However, I am having to use variable formulas such as Countif, Sumif, Countblank, etc for what I need. The problem is the 1st set of formulas I have created are not working for the rest of the document. It seems to only be specific to the range of cells the formula is currently in so when we make updates how do I know this will include the new cells and how can I get the formula to work for everything. Desperate for some seasoned Excel person to assist with this task.