| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula works on all worksheets except for 2
An empty cell is treated as 0. Dates are also numbers just format to show
time. Memphis!$F$4:$F$200<TODAY() is really 0 < 39902 "Jan" wrote: Update. I noticed that the worksheet where the formula doesn't work is including the value in the total row. But if that is the case, why wouldn't it include the total row of the other worksheets? The total row does not have a date value in the "F" column. "Jan" wrote: Hi, I'm using Excel 2003. This formula works in all worksheets except for 2 (note name of worksheet in formula is changed for specific worksheet) =SUMPRODUCT(--(Memphis!$F$4:$F$200<TODAY()),--(Memphis!$I$4:$I$200<0),--Memphis!$I$4:$I$200) The 2 worksheets that this formula doesn't work on have the smallest range. I want to use a consistent range in the formula and not have to change base on the number of rows each worksheet may have. Any advise on what could be wrong. TIA |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can excel add worksheets based on cell population in another works | Excel Worksheet Functions | |||
| Link to other Worksheets - when data is added updates master works | Excel Worksheet Functions | |||
| What is the formula that works for this | Excel Worksheet Functions | |||
| how do I generate lists in worksheets based on a master list works | Excel Worksheet Functions | |||
| How do I convert works file to excel without works software? | Excel Discussion (Misc queries) | |||
Threaded Mode
