Formulas SUM(INDIRECT(CONACATENTE( formula

[grphillips]

Can anymone explain this formula in excel in simple english. Step b
step. I am looking at the imput and output tables. I am looking at th
url link with a spreasheet methodology below

http://www.statistics.gov.uk/about/methodology_by_theme/inputoutput/downloads/Menu!A


You will notice this formula on one of the sheets.

Formula

=SUM(INDIRECT(CONCATENATE("'",$B$8,"'","!",C$31,$A40,":",C$32,$B40)))

I know sum is add up

Really don't know its use with the indirect function. Don't understan
it.

I know the concatenate function is join cells together. Don't know wha
the effect of

"'" - is within it
"!" - is within it
":" - is within it.

Thanks

 

[Aladin Akyurek]

CONCATENATE delivers a range-specifying string. INDIRECT resolves tha
string to the specified range whose contents it hands over to SUM
Without INDIRECT(), SUM() would just see a text-string and ignore it.