K
Karen Howard
Hi,
I have a spreadsheet set up with 2 worksheets. One
worksheet is for the "imported" data and the other is for
updating using cell referencing.
The only problem is that I want the "updated" spreadsheet
to calculate by using the =COUNT function. My problem is
that by the cells being referenced the calculation is
actually adding "blank cells" because of the formula (cell
reference).
How can I get my calculation to only add if there is an
actual "date" in the field and not add "cell referenced
formula's and/or blank cells"? Any suggestions. Thanks!
I have a spreadsheet set up with 2 worksheets. One
worksheet is for the "imported" data and the other is for
updating using cell referencing.
The only problem is that I want the "updated" spreadsheet
to calculate by using the =COUNT function. My problem is
that by the cells being referenced the calculation is
actually adding "blank cells" because of the formula (cell
reference).
How can I get my calculation to only add if there is an
actual "date" in the field and not add "cell referenced
formula's and/or blank cells"? Any suggestions. Thanks!