Fun and interesting challenge

[daniels012]

Try to use as many formulas as you can to get the simple result of:

A1 =4
A2 =5
A3 =2
A4 =5
A5 =1
A6 =0
A7 =0
A8 =6
A9 =2
A10 =1
A11 = "=SUM(A1:A10)" 'which the result is 26

Let's have some fun with it!!

An example to get the idea started would be:
=ROUND(SUM(A1:A10),0)
this gives the exact same result using 2 formulas...

Use as many formulas as you can without changing the value of the result 26.



Hve Fun!

 

[ExcelChampion]

=PRODUCT(QUOTIENT(SUMPRODUCT(--(ISNUMBER(A1:A10)),A1:A10),COLUMN(M1)),ROW(13:13))

 

[daniels012]

Nice 6 formulas!!!!! Go ahead and add the round as well

Michael

 

[Andrew Fergus]

I think I have to stop and do some work now because this is getting silly......
My contribution:

=ROUND(SUM(MOD(COUNT(A1:A10), MAX(A1:A10)+A1),PRODUCT(COLUMN(A:A),SUMPRODUCT(--ISNUMBER(A1:A10),A1:A10,--ISERROR(((CODE(TEXT(A1:A10,"0")))/MIN(A1:A10)))),LOG(LARGE(A1:A10,A1),A1)-INT(AVEDEV(A1:A10))),FACT(A1),SQRT(A1)),0)

19 unique functions! I might be able to slip the quotient and/or row functions in there too.....

If you evaluate this formula you will see it has been *highly* modified for the numbers given.


Andrew

{edited formula so it is no longer an array formula}

 

[Lewiy]

=AVERAGE(ROUND(SUM(MOD(CHOOSE(1,(COUNT(A1:A10))),MAX(A1:A10)+A1),PRODUCT((COLUMN(A:A)),SUMPRODUCT(--ISNUMBER(A1:A10),A1:A10,--ISERROR(((CODE(TEXT(A1:A10,"0")))/FLOOR(MIN(A1:A10),1)))),LOG(LARGE(A1:A10,A1),A1)-INT(AVEDEV(A1:A10))),FACT(A1),CEILING(SMALL(ABS(SQRT(A1)),1),1)),0))+(INT(RAND()*POWER(ODD(PI()*A1),0))+(INDIRECT("A"&ROW(A1))-A1))

I think that's 31 different functions

 

[daniels012]

Lewiy,
That looks awesome , now I need to go test it


I new this would be fun :wink:

Michael

{ edited: that indeed did the trick Lewiy }