Search results

@ Vletm: I'm talking about this form [=INDEX(C3:E3,2)]. It refers to the second row of range C3:E3 (which does not exist)

Yes, that's the oddity I'm talking about.

Yes, I did check thr syntax. Just try the example I gave in a blank worksheet and you'll see exactly what I mean.

I have used INDEX function with a horizontal array but I have made an error. The problem is that INDEX always returns the correct answer. Here is the case: Let's say you have the values "A", "B" and "C" in cells C3, D3 and E3. In a blank cell, type the formula =INDEX(C3:E3,2) (this formula...

@Lori : wow, thanks very much. This is a lot of new tricks for me. I liked your explanation about the "implicit intersection". I think this could be helpful to understand other functions. With regard to your formula to find attendance, I'd like to ask the following: what's the role of the...

@David: I always was "under the impression" that Sumproduct is "lighter" than array formulas requiring CSE. Thanks for pointing out that, though.

Hi Bosco, Thannnnks very much ... that's working perfectly That way, I can avoid the array formulas Naceur

You know what, I just tried with other simple formulas. Ex: Sum ( (.....) * (....) * (....)) [with and without Ctrl+Enter] Excel always gives the correct result if you open the dialog box by hitting the fx on the formula bar ... but if you don't use Ctrl+Enter then it shows an error...

Hi, I still don't understand why the IF function generates an array when I click on the fx symbol on the formula bar. It even gives the correct final result (-116) [see image below].... maybe Excel is assuming it's an array formula before I even hit the Ctrl+Enter ... but if that's the way...

Hi, @ Ramesh: Thank you very much for your solution. I actually wanted to avoid array formulas. I have a database of accounting entries of 250k lines. Array formulas may make it a very slow file to calculate. @Narayan: If the IF function does not output an array, then why the formula is...

Hi all, I'm trying to use the IF function within the SUMPRODUCT function. I'm getting some weird results; (#VALUE!) error. Can any one have a look at the sample file and let me know your thoughts? Thanks