Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel 2000
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. |
#2
|
|||
|
|||
Excel 2000
=SUMPRODUCT(--(AI5:AI133<""))
assuming that the formulas in AI5:AI133 will change to something when a date is entered in sheet1 -- Regards, Peo Sjoblom "j0white" wrote in message ... 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. |
#3
|
|||
|
|||
Excel 2000
This didn't work it still shows a total. The formulas in the cells are as
follows: ='New Bedford PFA REV 11'!G8 It places what is entered on the first sheet into that cell. Could it be something else? "Peo Sjoblom" wrote: =SUMPRODUCT(--(AI5:AI133<"")) assuming that the formulas in AI5:AI133 will change to something when a date is entered in sheet1 -- Regards, Peo Sjoblom "j0white" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |