| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula works on all worksheets except for 2
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
