Need to get the summary of all the compoent total

[anwitha]

I Need to get the total almount in the summary details from the table automatically even total column row moved to up or down. (i.e total column may move down if names are more similarly it may come down if names or less). PFA sample and do needful.

[Glenn Kennedy]

Easiest way is to convert it to a Table.

[anwitha]

Can this be done without using the tables?

[Glenn Kennedy]

Use this & copy across:

=INDEX(F:F,MATCH("total",$D:$D,0))

[anwitha]

Thanks. It works. Is it possible to get the total amount of a particualr header whenever i change teh header name in the summary. (Eg. in Summary table if change the Item1 header to Iteam2 i should get the item2 total amounts.

[Glenn Kennedy]

Is this what you meant?

=INDEX(F:I,MATCH("total",$D:$D,0),MATCH($F$17,$F$5:$I$5,0))

[anwitha]

Thanks a lot Glenn.

[anwitha]

Addition to the above formula, can i get the namewise total amounts??

[Glenn Kennedy]

Can you explain what you mean by that?

[anwitha]

I need to get the namewise total amount (Iteamwise). whenever i change teh name or component, with respect to that name and component total amount should appear. Attached the sample.

[samba_ravi]

See the attached file
F12=SUM(F6:INDEX(F:F,ROW()-1))
F18=F12
F20=SUMIF($D$6:$D$12,$D20,F$6:F$12)
TRY THIS AND COPY TOWARDS RIGHT

[anwitha]

Hi
Thanks for ur hlep.The formula should also include teh condition for COmponent name as well, if i change teh componet name from Item1 to Item2 also total should get changed as per the total amount of Item1.

[samba_ravi]

f18=INDEX($F$12:$I$12,MATCH(F$17,$F$5:$I$5,0))

Please Login or Register  to view this content.

f20=SUMIF($D$6:$D$12,$D20,INDEX($F$6:$I$12,,MATCH(F$17,$F$5:$I$5,0)))

Please Login or Register  to view this content.

Try this and copy towards right / across

[anwitha]

Thanks a lot

[samba_ravi]

You are welcome