Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() When a date is entered into a cell on worksheet 1, it populates that date in a cell on worksheet 2 in the same workbook. The formulas are setup in worksheet 2 to be blank unless a date is entered on worksheet 1. My question is this, I have counters at the top of each column "(=COUNTA(AI5:AI133)", this counts the cells that have data in them. How do I word this count formula on worksheet 2 to not count the cells unless a date is populated in that cell. Since there is a formula in each cell its counting the cells. I only want the cell to be counted when a date gets populated in worksheet 2, when a date is populated in worksheet 1. Any help will be greatly appreciated. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Can I lock info in Excel 2003 and users in Excel 2000 enter info? | Excel Discussion (Misc queries) | |||
Hyperlink in Excel 2000 can't open bookmarked Word 2000 file | Excel Discussion (Misc queries) | |||
Excel XP 2002 Vs. Excel 2000 | Excel Discussion (Misc queries) | |||
Excel 2000 file when opened in Excel 2003 generates errors? | Excel Discussion (Misc queries) |