Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell addressing
John,
Never thought of that, it works perfectly. Thanks, Mike "John" wrote: Try =COUNTIF(Database!E:E,"=yes") John "Mike" wrote: I'm sure I'm being daft here but I can't solve this seemingly simple problem. This statement below works fine except that whenever a new row is added to the top of the 'Database' worksheet; which is done with a VB macro when new data are added, the cell addresses increment i.e E2 becomes E3 etc. I've tried $E$2 but this doesn't work either. As a temporary measure the problem has been solved!! by rewriting the worksheet statement to the cell every time the macro runs to set the cell address back to E2 but there has to be a tidier way =COUNTIF(Database!E2:E10000,"=yes") Any guidance would be much appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct issues | Excel Worksheet Functions | |||
Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Indexing / Cell Addressing | Excel Discussion (Misc queries) |