| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
What wrong is it on using the indirect function?
Does anyone have any suggestions on what wrong it is on using the indirect
function? =SUM(--(TRANSPOSE(B$595:B$664)+A$2:A$90=H2)), which work fine, I would like to change B$595:B$664 into a variable using indirect function, =SUM(--(TRANSPOSE(INDIRECT("B$595:B$"&594+B$594))+A$2:A$9 0=H2)) but it returns #VALUE, does anyone have any suggestions what wrong this statement is on using indirect function? Thanks in advance for any suggestions Eric Note: This is an array formula that has to be confirmed with CTRL+SHIFT+ENTER rather than just ENTER |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What's wrong with this IF function. | Excel Discussion (Misc queries) | |||
| Using Indirect in a Sumif Function returns the wrong answer | Excel Discussion (Misc queries) | |||
| What is Wrong with this function?????????? | Excel Worksheet Functions | |||
| What am I doing wrong with PMT function? | Excel Discussion (Misc queries) | |||
| INDIRECT Function - what am I doing wrong? | Excel Discussion (Misc queries) | |||
Threaded Mode
