Excel - How many candles are lit during the Jewish Festival of Lights

 

Excel - How many candles are lit during  the Jewish Festival of Lights

 

Hanukkah, the Jewish Festival of Lights is just around the corner, and we want to know how many candles we’re supposed to use during the eight days of the holiday.

In Hanukkah, which lasts 8 days, we begin with two candles on the first day. In each consecutive day we add one more candle, so on the eighth and last day of the holiday we light 9 candles.

 

Now, the question is: How can we know in advance how many candles are needed?

 

Actually there are (at least) four solutions:

 

 

                        Solution No.1: SUM an array of numbers

 

                        Solution No.2: Gauss’s Formula

 

 

                  Solution No.3: SUM of a virtual array (no data!!!)

 

  Solution No.4: SUM of a virtual array created by SEQUENCE