"indirect" and "date" formula

Hello excel experts,
I am trying to create a dashboard and I saw a post on a website that talks about tweetboards. It is from someone named Fernando, and below is the original post.

Please Login or Register  to view this content.

It's a really neat idea, but there are 2 formulas that have me baffled.

1.

Please Login or Register  to view this content.

This formula is located in the 'company data' sheet, cell A17

2.

Please Login or Register  to view this content.

This formula is located in the 'company data' sheet, cell B18

I know vaguely what they do, but I'd appreciate if someone could explain it to me.

Thanks,
Amar.

P.S - Thanks to Fernando and Chandoo.org for making this spreadsheet available.

The second formula (in cell B18) essentially sums all the data in row 2 column 2 to row 9 column 2.

It could be more simply written as:

Formula:

Please Login or Register  to view this content.

Where the false tells the indirect function that the reference text ("R2C2:R9C2") is to be interpreted as an R1C1-style reference.

The other parts tell the formula which row and columns to look in.

I.e. using the column() function in column B returns 2 and in column C returns 3 etc.

The MATCH($A16,$A$2:$A$13,1) part of the formula searches for the month (A16) in A2:A13 and returns the position of the matched value within lookup_array (not the value itself). In this example its position in the array is 8 so they add 1 to give the row that the value is in - row 9.

The &'s simply join up the text strings

So putting it all together you have:

Formula:

Please Login or Register  to view this content.

or

Formula:

Please Login or Register  to view this content.

or

Formula:

Please Login or Register  to view this content.

Thanks for helping me out guys. Appreciate it.

Amar.