Hi,
I have a template where sheet 1 is for entering data and sheet 2 is formatted and has formulas to work out calculations.
the tables in each sheet are set to 210 rows with row 1 in each being the header.
In a scenario there could be 100 rows of data entered and then saved as another file or all 210 rows of data entered and then saved as. The original document is a template to be used time and time again.
the issue I am having is in sheet two, when there is only 100 rows of data entered in sheet 1 I am getting 110 "0s" in the remaining rows which is messing with my count calculations. Some of the data entered might be a 0 so these count towards the calculations.
I am racking my brains on trying to get the cell reference formula to return a blank.
this is the simple reference formula in the cells in sheet 2.
Can some one add to this (I know its really simple yet I just cant get it to work and I cant seem to fine anything else where).
Thanks in advance
Bookmarks