Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Referencing
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell Referencing | Excel Worksheet Functions | |||
Cell Referencing | Excel Worksheet Functions | |||
Cell Referencing | Excel Discussion (Misc queries) | |||
cell referencing | Excel Worksheet Functions | |||
Referencing Cell Next To Today's Date Cell | Excel Discussion (Misc queries) |