| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Entered data for use in formula
I am trying to make formulae that is used regularly be more user friendly.
Is there a way I can enter a range and use that input data in a formula. e.g. in A1 type "D3" and A2 type "D50" B1 type "E3" B2 type "E50" then use D3:D50 and E3:E50 in a formula, e.g. =SUMPRODUCT(--(D3:D50<1000),--(E3:E50)). I have tried many variations but none seem to work. Any help would be appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula changes as new data is entered... | Excel Discussion (Misc queries) | |||
| Macro: Updates a formula or value when a data is entered. | Excel Worksheet Functions | |||
| extend formula when data is entered | Excel Worksheet Functions | |||
| Data not entered yet - formula calculate blank | Excel Discussion (Misc queries) | |||
| Formula Changes when data entered in referenced range | Excel Discussion (Misc queries) | |||
Threaded Mode
