how to find the total value

[sudipto3003]

Dear friends,
I have an excel sheet where the values are of "Taxable" and "Tax" against many locations. I need a formula at the same sheet in column BG and BH the total of "Taxable" and "Tax" of 12 months according the locations. I have attached herewith a sample sheet. Please help.

 

[Asheesh]

Hi Sudipto...

Check if this helps...used helper columns to keep it simple & light

 

[Somendra Misra]

Hi Sudipto,

Another alternative.

Regards,

 

[kchiba]

Hi Sudipto,

Look at attached file

cheers

kanti

 

[sudipto3003]

hi every one,
thanks to all to solve the problem so early, I will go with "Somendra" which is easier to me.

 

[himanshu sharma]

FOR TAXABLE: =INDIRECT(ADDRESS(21,MATCH(BF9,$A$5:$BA$5,0)))
FOR TAX: =INDIRECT(ADDRESS(21,MATCH(BF9,$A$5:$BA$5,0)+1))
USE THIS FORMULA TRICKS